Sql Stored Procedure
-
Hi To ALL! Can any one tell me the max no of input parameter and also output parameter supported in stored procedure (sql server 2000) Another problem that i face is that i need to convert the sql server 7 database to sql server 2000 database. Thanks for your valuable help Mahesh
-
Hi To ALL! Can any one tell me the max no of input parameter and also output parameter supported in stored procedure (sql server 2000) Another problem that i face is that i need to convert the sql server 7 database to sql server 2000 database. Thanks for your valuable help Mahesh
-
A stored procedure can have a maximum of 2,100 parameters http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_create_4hk5.asp[^]
Thank You Very Much... You mean 2100 parameters is a combination of input,output,return.
-
Thank You Very Much... You mean 2100 parameters is a combination of input,output,return.
yes the total number. Tom Wright tawright915@yahoo.com