How many OUTPUT parameters can be declared for a stored procedure in SQL Server?

Question

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

Answer 1

According to MSDN , a stored procedure can contain no more than 2100 parameters. The limit applies to all parameters regardless of their direction (input or output).

However, I would advise you to keep the number of parameters relatively low. If you are returning a lot of data or a lot of data, use a result set instead.

Answer 2

Mostly almost as much as you like; -)

SQL Server, - 2'100. , 2100, ...

Answer 3

2100 on MSDN Documentation .

Answer 4

You are limited only by the number of parameters that can be stored in the stored procedure, which is 2100 (SQL 2005/2008).

From MSDN :

A stored procedure can have a maximum of 2100 parameters