parameters in an Stored procedure(SQL server 2005)

  • Thread starter Thread starter iHavAQuestion
  • Start date Start date
I

iHavAQuestion

I am working on an application where I need to pass 410 parameters (most of
them being optiona)l to a stored procedure.
I just wanna know will an stored procedure in SQL server 2005 will accept so
may parameters and will they be any issues...
 
iHavAQuestion said:
I am working on an application where I need to pass 410 parameters (most of
them being optiona)l to a stored procedure.
I just wanna know will an stored procedure in SQL server 2005 will accept
so
may parameters and will they be any issues...
Click to expand...

This is a link to MS docs with limits for just about anything you can think
of for SQL Sever 2005

http://msdn.microsoft.com/en-us/library/ms143432.aspx

Says that you can have 2100 parameters . Good luck.



Hope this helps
Lloyd Sheen
 
Back
Top