As a TSQL Developer or DBA, while writing TSQL code for the business login or DBA maintenance tasks, we come across the situation to work on temporary data. To accomplish this, we generally use temporary table or table variable. The most confusing problem is “which one is the best for my algorithm?” This is a question which creates lots of confusion between TSQL professionals. The reason for this confusion is the lack of knowledge about the differences between temporary table and table variable. In this lab, we will learn about the various differences between temporary table and table variable such as scope, schema modification, cardinality estimation etc. After completion of this lab, we will be able to choose the best one to use in our TSQL code.

Subscribe to Download


Version1.0
Download4
File Size863.77 KB
Create DateSeptember 12, 2016
Last UpdatedSeptember 12, 2016
TOP and APPLY Operators in SQL Server
SQL Server Stored Procedures