SQL Temporary Tables Archives - Technology with Vivek Johari

SQL Server-Table Variable

January 10, 2012January 28, 2019 vivekjohari4 Comments

Table variable:- SQL Server provides an variable known as table variable which is used to store data in a similar way as we store data in physical tables but with some limitations. Like other SQL variable, it is also declare with the help of the Declare keyword with @ prefix. The Syntax of declaring a table variable is […]

SQL Server – Local temporary table

January 7, 2012January 28, 2019 vivekjohariLeave a Comment

Local temporary table:- Local temporary table is created in the tempdb and it is visible to the current user’s session only. It remains exists till the current user session is connected. Once the user connection is disconnected it gets destroyed. Since the local temporary table is created in the tempdb, whenever we use temporary tables […]

SQL Server – Global temporary tables

January 7, 2012April 27, 2018 vivekjohari31 Comments

Global temporary table:- Global temporary table is created in the tempdb and it is visible to all other sessions as well. Global temporary tables are only destroyed when the current user disconnected and all the sessions referring to it closed. It means no user sessions refers it. Since the global temporary table is created in the tempdb, whenever we […]