Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

interview

home / developersection / interviews / what is the differences between local and global temporary tables in sql server?
Ask Question
Anupam Mishra
Anupam Mishra

Other

Message

1 Answers

Anupam Mishra
Anupam Mishra 26 Feb 2016
Report Abuse
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)
) 
MindStick Training