interview

Home / DeveloperSection / Interviews / What is the differences between local and global temporary tables in sql server?

Ask Question
Anupam Mishra

Anupam Mishra

Follow

Can you answer this question?

Answer

1 Answers

Anupam Mishra

Anupam Mishra

26-Feb-2016
Global Temp Variable:
Global temp tables name starts with double hash (##) in sql server. Once this table is created in database, it is like a permanent table in tempdb->temporary tables. It is always ready for all users and not deleted until the total connection is withdrawn.

CREATE TABLE ##StudentTemp
 (  
Username varchar(50),  
User_address varchar(150)
) 
Local Temp Variable:
Local temp tables are only available at current connection time in sql server database. It is automatically deleted when user disconnects from instances. It is started with hash (#) sign.

CREATE TABLE #localTemp
 (  
Username varchar(50),  
User_address varchar(150)
) 

Liked By