But, if you're using any version of SQL Server later than SQL Server 2005, you have an alternative: table-valued parameters. Table-valued parameters let you pass a collection of table rows as a ...

SQL Server 2008 introduces the ability to pass a table data type into stored procedures and functions. The table parameter feature can greatly ease the development process because you no longer ...