Temp Tables Versus Table Variables Versus Common Table Expressions

SQL Server 2012 provides multiple options for working with temporary result sets in T-SQL code:

Image Temporary tables

Image Table variables

Image Derived tables

Image Common table expressions

One of the questions you may consider is, “Which method should I use and when?” Whether you use a temporary table, ...

Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial