Explore

SQL Server FAST TRACK - Temp Tables and Table Variables

2 hours on-demand video

$ 12.99

Save Course

Go to Course

Brief Introduction

Get up to speed quickly with TEMP TABLES and TABLE VARIABLES. Learn how they work and when to use which table type.

Description

This is an in depth course about programming with TEMP TABLES and TABLE VARIABLES in SQL Server. It assumes that the student has at least a rudimentary understanding of database concepts and architecture and gets right into the meat of the subject.

Temp tables and table variables can solve a lot of the trickier challenges faced by developers so you need to become expert with them.

This course will get cover all of the following:

TEMP TABLES

Temp Tables and the Temp Database (tempdb)

Persistence

Persistence in STORED PROCEDURES

Persistence - TSQL vs STORED PROCEDURES

Command Line TSQL examples

IDENTITY column usage

STORED PROCEDURE usage

Command Line TSQL vs STORED PROCEDURE

TEMP TABLES vs REAL TABLES

TABLE VARIABLES

No Persistence

Command Line TSQL examples

IDENTITY column usage

STORED PROCEDURE usage

USER DEFINED FUNCTION usage

Table Variables vs Temp Tables: How they are similar and how they differ

Benefits and drawbacks to each type

Requirements

Requirements
The student should have a basic understanding of databases. It would also be beneficial to have SQL Server installed on the student's computer.