CTE In Sql server

Question

what is CTE?what is the Use of it?where we have to use of it.with example.what is advantage of using it.

Riddhi Valecha · Answer

Hi.. Refer the links - http://www.sqlservergeeks.com/articles/sql-server-bi/38/sql-server-%E2%80%93-what-is-common-table-expression-cte https://www.simple-talk.com/sql/t-sql-programming/sql-server-2005-common-table-expressions/ These links have examples. It depends if you want the output as shown in the link you can use CTE.

Rosi Sreenivasa Reddy · Answer

what is the difference between simple CTE and Recursive CTE?

Rosi Sreenivasa Reddy · Answer

definition of CTE with Realtime Example.what is exact scenario to use it.

Riddhi Valecha · Answer

CTE - Common Table Expression. --- http://technet.microsoft.com/en-us/library/ms190766%28v=sql.105%29.aspx http://blog.sqlauthority.com/2011/05/10/sql-server-common-table-expression-cte-and-few-observation/ Hope these sites help.