Global temporary table in SQL server | Part - 12

Global temporary table in SQL server | Part - 12 Welcome to Tutorial007 and in this video, we will learn what is global temporary table in sql and how to declare global temp table and insert into global temp table. A local temporary table exists only for the duration of a connection or, if defined inside a compound statement, for the duration of the compound statement. Local temp tables are only available to the SQL Server session or connection (means single user) that created the tables. A temporary table in SQL Server, as the name suggests, is a database table that exists temporarily on the database server. A temporary table stores a subset of data from a normal table for a certain period of time. ... Temporary tables are stored inside “tempdb” which is a system database. The answer is that temporary tables (local and global) are stored in the tempDB database. Explanation: When you declare a temporary table, SQL Sever adds some additional characters on its name in order to provide a unique system name for it and then it stores it in tempDB in the sysobjects table. What is #table in SQL Server? SQL Server stores the data that defines the configuration of the server and all its tables in a special set of tables known as system tables. Users cannot directly query or update the system tables. For get source code of example related to the video navigate to the below link : https://techtalktricks.blogspot.com/ My Gadgets : ►Laptop : https://amzn.to/2UlVZq7 ►Mic : https://amzn.to/2Scq3al ►Tripod : https://amzn.to/2TfND3e ►Phone : https://amzn.to/2UroWkN At Tutorial007 you will learn Mini Project for College, Website Development, Web Design, Web Development, HTML, CSS, SQL, PL/SQL, JAVA and many more computer as well as mobile tips and tricks. So please SUBSCRIBE to getting updated with the latest technology. #tutorial007 #globaltempTable #temptable #sqlServer #devian_rana #databaseTutorial #techtalktricks #ranasingh #webdesign #webdevelopment #website Topic Covered: global temporary table in sql with example, table variable in sql server, global temp table sql server disadvantages, why we use temp table in sql server, sql server temp table performance, difference between local temporary table and global temporary, sql server temp table best practices, sql server virtual table, SUBSCRIBE our channel at : https://www.youtube.com/Tutorial007 ************************************************** Follow Tutorial007 on Facebook https://www.facebook.com/Tutorial007 ************************************************** Follow Tutorial007 on Twitter https://twitter.com/Tutorial007 ************************************************** Follow Tutorial007 on Instagram https://www.instagram.com/Tutorial007.Official ************************************************** Subscribe Tutorial007 on YouTube https://www.youtube.com/Tutorial007 ***************************************************