Summary

Many topics covered in today's lesson. The first topic we discussed today was how to define and use variables in your SQL programs to store data for later use. You also learned many of the fundamental concepts of using T-SQL as a programming language. This includes controlling the flow of your program code as it is executed by using the IF and WHILE statements to test conditions. In addition, you learned how to group statements together in blocks using the BEGIN…END statements.

In the second half of the day, you learned about error processing and the variables and features that SQL Server provides you with to identify errors and even add your own features to the system. Finally, by combining many of today's concepts, you saw how to test for an error and then execute a grouping of SQL code if an error did occur.