Temparary tables and CTE and Table variables

Question

Difference between Temparary tables and CTE and Table variables

Ravi Patel · Answer

Hi  go through this link https://www.youtube.com/watch?v=oGuS1rdfaMI https://www.youtube.com/watch?v=ZXB5b-7HJHk

Sundar · Answer

Follow these links this may help you 1) http://www.dotnettricks.com/learn/sqlserver/difference-between-cte-and-temp-table-and-table-variable 2) http://www.c-sharpcorner.com/article/difference-among-cte-derived-table-temp-table-sub-query/