Introduction to Table-Valued Parameters with Example

home
database
view story

4 Kicks

Introduction to Table-Valued Parameters with Example(blog.sqlauthority.com)

submitted by pinaldave(9662) 3 years, 8 months ago

Table-Valued Parameters is a new feature introduced in SQL SERVER 2008. In earlier versions of SQL SERVER it is not possible to pass a table variable in stored procedure as a parameter, but now in SQL SERVER 2008 we can use Table-Valued Parameter to send multiple rows of data to a stored procedure or a function without creating a temporary table or passing so many parameters. This is one feature all the SQL Server developer were waiting for long time. This article explains how it can be used with very simple words.

1 comment |category: Database |Views: 52
Tweet