How to pass a variable number of parameters to a SQL Server stored procedure ?
- by Kumara
I used SQL Server 2005 for my small web application. I Want pass parameters to SP .
But there is one condition. number of parameter that can be change time to time.
Think ,this time i pass name and Address , next time i pass name,surname,address ,
this parameter range may be 1-30 ,