How many OUTPUT parameters can we declare for a stored procedure in SQL Server ?
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.