top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Why CTE is used in SQL Server

+2 votes
296 views
Why CTE is used in SQL Server
posted Dec 6, 2013 by Neeraj Pandey

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote

CTE stands for Common table expression. sometimes it is very useful when you are writing a complex query.

Consider a case where you want data from more the 4 tables and then you want to insert into a temp table based on some conditions and then you want to return the result.

In such kinds of scenarios CTE is the best option..

answer Jan 13, 2014 by Atul Mishra
...