In Transact-SQL (T-SQL), temporary tables let users store and process intermediate results. Users can perform all the operations on temporary tables as like in SQL server tables. This lab is divided into seven exercises. In the first exercise, we will learn about local temporary tables. In the second exercise, we will learn about global temporary tables. In the third exercise, we will learn about temporary tables in stored procedures. In the fourth exercise, we will learn the behavior of temporary tables in dynamic SQL. In the fifth exercise, we will learn the behavior of temporary tables in various modules such as stored procedures, user-defined functions, triggers and views. In the sixth exercise, we will learn about collation in temporary tables. The seventh exercise is about self-assessment, where a problem needs to be solve on your own.
Exercise 1: CREATE and use a Local Temporary Table
Exercise 2: CREATE and use a Global Temporary Table
Exercise 3: Temporary tables in stored procedures
Exercise 4: Temporary tables in dynamic SQL
Exercise 5: Temporary tables in Modules
Exercise 6: Collation in temporary tables
Exercise 7: Self-Assessment