Common Type expression

Question

What is CTE? Where we can apply?

Govinda Rajulu Yemineni · Answer

CTE stands for Common Table expressions. It was introduced with SQL Server 2005. It is a temporary result set and typically it may be a result of complex sub-query. Unlike temporary table its life is limited to the current query. It is defined by using WITH statement. CTE improves readability and ease in maintenance of complex queries and sub-queries. Always begin CTE with semicolon. if you want to store data temporarily we use CTE and we can also have alternatives like Temp Table and Temp Variable to store data temporarily. you can find more information on these in the following URL http://www.dotnet-tricks.com/Tutorial/sqlserver/X517150913-Difference-between-CTE-and-Temp-Table-and-Table-Variable.html

Raja T · Answer

Hi Please check below link for what is CTE and where we can applying https://technet.microsoft.com/en-us/library/ms186243(v=sql.105).aspx

Suyambu Kesavan · Answer

Thanks for your Link

Manas Mohapatra · Answer

Hi CTE is a temporary result set in Sqlserver which helps a developer to write complex queries and to implement recursive query. Below link help you to understand about CTE http://www.codeproject.com/Articles/265371/Common-Table-Expressions-CTE-in-SQL-SERVER