SQL Server Temporary Tables

Home/Development, SQL Server/SQL Server Temporary Tables

SQL Server Temporary Tables

$15.00 $4.00

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

Categories: ,

Description

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

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

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.