"What is A CTE?
A CTE is a temporary view that exists only in the scope of running query. A CTE is similar to a view but a CTE is embedded into the query. CTEs can be used in Stored Procedures, User Define Functions (UDFs), Triggers and Views but not in Indexed Views."
A article, by Dinesh Asanka, about CTE, is usage and advantages.
Common Table Expressions (CTE) for SQL Server Developers
Sem comentários:
Enviar um comentário