Some Important T-SQL Programmability feature of SQLSERVER 2008

There are lots of new feature introduced with SQLServer 2008 for improving the SQL experience of developers. Here we will cover some very important and useful features of SQLServer 2008. Features which we are going to cover is –

1. Declaring and initializing new variables.
2. Compound assignment operators
3. Table value constructor
4. Enhanced Convert Function
5. Date and Time Data types
6. Table Type