Transact SQL Enhancements in SQL Server 2005 – Common Table Expressions

(Mahesh) A new feature in SQL Server 2005 is the introduction of a new virtual table (rather a ResultSet) called Common Table Expressions (CTE). CTE stores temporarily the results set during the execution of a SELECT, INSERT, UPDATE or DELETE statement. The advantage of using CTE is the ability to w

Read More - Register for Free Membership