Is there any simple way to add more params in storeprocedur

Question

Can we pass more parameters at a time to stored procedure instead of pass input varaibles step by step?

Vulpes · Answer

If you're asking whether you can pass a variable number of input parameters to a stored procedure then in SQL Server you can use a table-valued parameter. Check this SO thread for a discussion of these: http://stackoverflow.com/questions/11102358/how-to-pass-an-array-into-a-sql-server-stored-procedure