Previous

Next

Introduction

Completed

Transact-SQL (T-SQL) provides a robust programming language with features that let you temporarily store values in variables, apply conditional execution of commands, pass parameters to stored procedures, and control the flow of your programs.

In this module, you'll learn how to enhance your T-SQL code with programming elements.

After completing this module, you'll be able to:

• Describe the language elements of T-SQL used for simple programming tasks.
• Describe batches and how they're handled by SQL Server.
• Declare and assign variables and synonyms.
• Use IF and WHILE blocks to control program flow.

Continue