How many parameters can be passed to a MS-SQL stored procedure?
Sanjay Dixit
2100 check aspmaterials.blogspot.com
2,100
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.
For a Professional ResumeHave Your Resume Written By America's Leading Resume Writers
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
Up to 1024http://dotnet-developers-cafe.blogspot.in/p/sql-interview-part-1.html
We can pass max 2100 parameters.Rgds Kareem Syed www.optimizesql.com/blog
Only 2.
Parameters passed in stored procedure (32bit and 64bit) - 2,100