Hands-On-Lab: SQL Server Temporary Tables

Home/HOLs/Hands-On-Lab: SQL Server Temporary Tables

Hands-On-Lab: SQL Server Temporary Tables

Hello Friends,

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.

Learn More


Happy Learning – The Practical Way.

Data Platform Virtual Summit 2020

Subscribe to SQLMaestros YouTube channel. If you want more learning content in your inbox, subscribe to SQLMaestros Bulletin.

SQLMaestros YouTube | SQLMaestros Bulletin | SQLMaestros Twitter

By |2020-09-01T12:44:01+05:30July 28th, 2020|HOLs|0 Comments

About the Author:

Leave A Comment