SQL Server 2008 (and ADO.NET in .NET Framework V3.5) have a capability whereby you can pass a whole table of data into a stored procedure in one go. Rather than passing XML or a string, multi-valued parameters can be represented quite naturally.
In this video, we take a quick look.
Comments