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

Question

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

Answer 1

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......

Answer 2

2100 as per MSDN documentation.

Answer 3

You're only limited by the number of parameters a stored procedure can have which is 2100 (SQL 2005/2008).

From MSDN:

A stored procedure can have a maximum of 2,100 parameters

Answer 4

According to MSDN, a stored procedure can have a maximum of 2,100 parameters. The limit applies across all parameters, regardless of their direction (input or output).

However, I would advice you to keep the number of parameters relatively low. If you're returning many pieces of data or a lot of data, consider using a result set instead.