There is lots of confusion regarding this questions that is the “Maximum Limits Specifications” of Parameters per stored procedure. In Books Online it’s mentioned as 1,024 this is incorrect states. Actually the maximum number of parameters in a stored procedure is 2,100,the number of parameters from 1,024 was significantly increased from SQL Server 7. The [...]
Archive for the ‘Stored Procedures’ Category
Maximum Number Of Parameters Accepted Per Stored Procedure.
Posted in Stored Procedures on March 31, 2010 | Leave a Comment »
