Here is another popular lab from Hands-On-Lab library: SQL Server Temporary Tables.
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
SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.