Temporary Tables in T-SQL
Temporary Tables are a handy technique for creating cascading logic. Results from one temporary table can be passed to other temp tables. This can simplify the process for creating complex result sets.
Temporary tables are saved to disk, and are visible in the tempdb database in the system database folder. As they are saved to disk, they can be used to manipulate larger datasets than say table variables that save the result set to memory/RAM.
Temp Tables fall into two categories- local & global temp tables. Local are accessible only to current session while global are accessible to other sessions.
I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-...
Watch video Temporary Tables in T-SQL online without registration, duration hours minute second in high quality. This video was added by user Analyse US 08 August 2013, don't forget to share it with your friends and acquaintances, it has been viewed on our site 6,08 once and liked it 2 people.