May 2, 2003 at 7:26 am
What is the number of maximum input parameters for stored procedure in SQL Server 2000?
May 2, 2003 at 9:03 am
According to BOL (look under 'limitations-SQL Server objects'), the maximum no of parameters is 2100.
It doesn't specify whether there is a specific limit on input vs output parameters.
Not sure if there is a limit
May 2, 2003 at 9:12 am
SQL 7 is 1024
SQL 2K is 2100
Found under Create Procdure in BOL for property of n argument.
All can be Input or Output.
Edited by - antares686 on 05/02/2003 09:12:26 AM
May 2, 2003 at 9:34 am
Thanks both.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply