Table-Value Parameters in SQL Server 2008

home
other
view story

2 Kicks

Table-Value Parameters in SQL Server 2008(dotnethitman.spaces.live.com)

submitted by misbaharefin(845) 3 years, 9 months ago

One of the cool new data types added in SQL Server 2008 is Table-Value Parameters. You can use table value parameters to send multiple rows of data to a Transact-SQL statement, or to a routine such as a stored procedure or function. This can be done without creating a temporary table or many parameters. Table-value parameters are like parameter arrays in Object Linking and Embedding Database (OLE DB) and Open Database Connectivity (ODBC), but offer better flexibility and closer integration with Transact-SQL. Table-value parameters can participate in set-based operations.

add a comment |category: Other |Views: 26
Tweet