How many parameters can be passed to a MS-SQL stored procedure?

2100 check aspmaterials.blogspot.com

2,100

2100

2100

2100

2100

2,100

2,100

2,100

2100

2100

Total number of parameters (Input + Output) in a stored procedure is 2100. However, there is no information of how many are for input or output.

Total number of parameters in a stored procedure (Input+Output) is 2100. However, there is not any further explanation to how many of this 2100 are for input or output.

Parameters per stored procedure (32bit and 64bit) 2,100 Pls refer the link below for more interesting information http://msdn.microsoft.com/en-us/library/ms143432.aspx

You can pass upto 2100 parameters to sql server stored procedure - See http://msdn.microsoft.com/en-us/library/ms143432.aspx

2,100

Up to 1024 http://dotnet-developers-cafe.blogspot.in/p/sql-interview-part-1.html

We can pass max 2100 parameters. Rgds Kareem Syed www.optimizesql.com/blog

2,100

2,100

Only 2.

Only 2.

Parameters passed in stored procedure (32bit and 64bit) - 2,100

2,100

2,100

2100