title: How to pass a variable number of parameters to a SQL Server stored procedure?
body: <p>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 ,</p>
  
  <p>this parameter range may be 1-30 , </p>