SQL server 2005 Features

Development Features * CommonTableExpressions Which returns a record set in a statement. CTE can be thought of as a temporary result set which can be defined in the SELECT,INSERT,UPDATE and DELETE statements. CTE can be self-referencing and can be referenced multiple times in the same query.