Program with Transact SQL 

Introduction

Describe T-SQL for programming

Describe batches

Declare and assign variables and synonyms

Use IF and WHILE blocks to control program flow

Exercise: Program with T-SQL

Knowledge check

Summary

Introduction

Call stored procedures

Pass parameters to stored procedures

Create a stored procedure

Use dynamic SQL with EXEC and sp-execute-sql

Create user-defined functions

Exercise: Create stored procedures and table-valued functions

Knowledge check

Summary

Introduction

Implement T-SQL error handling

Implement structured exception handling

Exercise: Implement error handling with Transact-SQL

Knowledge check

Summary

Introduction

Describe transactions

Compare transactions and batches

Create and manage transactions

Handle errors in transactions

Describe concurrency

Exercise: Implement transactions with Transact-SQL

Knowledge check

Summary