Analytics in Action

Creating Temporary Tables with Transact 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.

Udemy Button