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