SQL Server 2008 R2 Specification Limits – Maximum Parameters to Stored Procedures and Functions

By Santhosh N

This explains about the maximum number of parameters allowed in Stored Procedures and functions in SQL Server 2008 R2.

SQL Server allows parameters to the Stored Procedures and functions and they can be of three types namely INPUT, OUTPUT, INPUT and OUTPUT.


SQL Server 2008 R2 restricts the number of parameters allowed in Stored Procedure and Functions and they are limited to 2,100.


Note: This hold common for both 32-bit and 64-bit SQL Server.

Related FAQs

This explains about the limitation of the number of columns allowed in the SELECT, INSERT and UPDATE Queries in the SQL Server.
This explains the maximum number of columns allowed for keys (Primary, index and foreign keys) in SQL Server.
This explains the maximum size in bytes that is allowed for keys (Primary, index and foreign keys) in SQL Server.
This explains the maximum size of the STRING Data type Columns’ value allowed by the SQL Server.
This explains about the creation of NON-CLUSTERED indexes and maximum allowed.
This explains the best scenarios to create CLUSTERED index on the table in SQL Server.
SQL Server 2008 R2 Specification Limits – Maximum Parameters to Stored Procedures and Functions  (1876 Views)