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 ...

Table-valued parameters are a new feature introduced in SQL Server 2008. They provide a built-in way to send multiple rows of data from a client application to SQL Server in a single parameterized ...

Stephen Glasskeys For reporting uses, XML parameters really shine: You can pass the same XML string to multiple stored procs, yet you won’t need to modify all of them, if say, one report’s ...