Codechef4u is a community for computer professionals,by computer professionals,just like you; who loves sharing and helping each others,Join them
Share your post


Common Table exp ression (CTE in SQL) is a temporary result set that, derived from query (T-SQL query in MS SQL Server) And defined within the execution scope of a Select, Insert, Update, Delete statement.

Some disadvantages or cons using CTE

1. CTE cannot be nested like views.

2. Not possible to reuse in another query like view or function, reason a CTE is just shorthand for a query or subquery.

3. Possible performance issue in case of frequently used query(If CTE is used in that query).


in follwing thread shared some advantges using CTE

Share your answer

Share as a guest

Please subscribe me to the CodeChef4U.

By creating your new answer, you agree to the privacy policy and terms of service.