Good Articles about passing many arguments to a stored procedure

Good Articles about passing many arguments to a stored procedure


Have you ever wanted to pass a DataTable, or array, containing tens or tens of thousands (or even millions) of records, into a SQL Server2000 stored procedure in just one database call? Ever wanted to pass a list of IDs of records to select or delete into a SP? Then read on.

Passing an array or DataTable into a stored procedure

How to pass a list of values or array to SQL Server stored procedure

Multi-table insert/update using XML