Categories
General

Variable and Assignment enhancements

Variable and assignment enhancements are small plus points in SQL Server 2008. We have around 4 things to discuss under this and they are below. All of these are mostly helpful to developers.

Categories
DBA

Table Valued Parameter – SQL 2008

A new T-SQL feature is available in SQL Server 2008 which allows us to pass a set of rows as a parameter to stored procedures or functions. Table-Valued Parameter (TVP) allows us to send multiple rows of data to a stored procedure or a function without the need to pass so many parameters or creating temp tables.