Common table expressions (CTE) introduced in SQL Server 2005. It is a temporary result set that can be used within the scope of another query or a data manipulation statement, such as an INSERT, UPDATE , DELETE,Create View statement. This table's contents can be referenced multiple times in the main query or update command.
References:
http://www.blackwasp.co.uk/SQLCTEs.aspx
http://blog.sqlauthority.com/2008/07/28/sql-server-simple-example-of-recursive-cte/
http://blog.sqlauthority.com/2009/08/08/sql-server-multiple-cte-in-one-select-statement-query/
References:
http://www.blackwasp.co.uk/SQLCTEs.aspx
http://blog.sqlauthority.com/2008/07/28/sql-server-simple-example-of-recursive-cte/
http://blog.sqlauthority.com/2009/08/08/sql-server-multiple-cte-in-one-select-statement-query/
No comments:
Post a Comment