What is the differences between local and global temporary tables in sql server?

Question

Anupam Mishra · Answer

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-andgt;temporary tables. It is always ready for all users and not deleted until the total connection is withdrawn.CREATE TABLE ##StudentTempand ( and Username varchar(50), and User_address varchar(150))and 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 #localTempand ( and Username varchar(50), and User_address varchar(150))and

interview

What is the differences between local and global temporary tables in sql server?

Anupam Mishra

Can you answer this question?

1 Answers

Liked By