How any information returned to the client should be done via a result set.

Question

Hi All I was just going through SQL server database standards wherein I found these statements mentioned below. But I actually did not understand how they are justified. Thank you in advance for any information. 1. Do not use output parameters. Any information returned to the client should be done via a result set. 2. Do not create stored procedures that return multiple result sets.

Jean Paul · Answer

Hello Manish The statements says that: 1. We can return result through output parameters CREATE PROCEDURE GetImmediateManager @employeeID INT @managerID INT OUTPUT http://msdn.microsoft.com/en-us/library/ms378108(v=sql.90).aspx B ut this is not the recommended way and one should use the result set (Use SELECT statement in return) 2. Multiple result set not advised. In applications usually a stored procedure returns only one result set. But stored procedures can return multiple result sets. Eg: CREATE PROCEDURE GetMultipleResultSets SELECT * FROM Table1 SELECT * FROM Table2 The above case is not recommended.