Return Result Set Sql Server Stored Procedure. For example storedprocedure1 should call storedprocedure2 and return that output. In addition the output parameters can be in any valid data type eg integer date and varying character.
The procedure fetches the first 5 rows of result set RS. Note To view Transact-SQL syntax for SQL Server 2014 and earlier see Previous versions documentation. 2000 2005 2008 2008R2 2012 and 2014.
The procedure fetches the first 5 rows of result set RS.
2000 2005 2008 2008R2 2012 and 2014. Please refer to the Select Stored Procedure article to write Select statement inside a stored procedure. Always return only one result set. Note To view Transact-SQL syntax for SQL Server 2014 and earlier see Previous versions documentation.