How many OUTPUT parameters can we declare for a stored procedure in SQL Server?

sql-server stored-procedures out-parameters
odiseh picture odiseh · Feb 23, 2010 · Viewed 9.6k times · Source

How many OUTPUT parameters can we declare for a stored procedure in SQL Server ?

Answer

marc_s picture marc_s · Feb 23, 2010

Basically almost as many as you like ;-)

If you check this Technet article Maximum Capacity Specifications for SQL Server, the maximum number of parameters for a stored procedure is 2'100. I don't see any mention whether or not you couldn't have all 2100 being output parameters, if you really must......

Related questions

Insert results of a stored procedure into a temporary table

How do I do a SELECT * INTO [temp table] FROM [stored procedure]? Not FROM [Table] and without defining [temp table]? Select all data from BusinessLine into tmpBusLine works fine. select * into tmpBusLine from BusinessLine I am trying the same, but …

Read More
Search text in stored procedure in SQL Server

I want to search a text from all my database stored procedures. I use the below SQL: SELECT DISTINCT o.name AS Object_Name, o.type_desc FROM sys.sql_modules m INNER JOIN sys.objects o ON m.object_…

Read More
SQL Server - SELECT FROM stored procedure

I have a stored procedure that returns rows: CREATE PROCEDURE MyProc AS BEGIN SELECT * FROM MyTable END My actual procedure is a little more complicated, which is why a sproc is necessary. Is it possible to select the output by …

Read More