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. Declare Statement Compound Assignment Operators Row Constructors Table Valued Parameter (TVP) Lets discuss on this titles one by one

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… Continue reading Table Valued Parameter – SQL 2008