How to pass large number of parameters in stored procedure from code to MS SQL
- by Ashwani K
Hello All:
How to pass a large number of parameters (say 20+) to stored procedure from code.
Like we can group all the parameters in one class object and then pass it across, but how to implement such this in case of stored procedures.
Currently I have to create 20+ variables to pass parameters.
Thanks
Ashwani