Chapter Summary

This chapter has covered a significant amount of what it takes to be a real SQL Server programmer. You should now have an understanding of how basic looping and conditional statements can be used within a batch and how SQL Server handles locks. You have also seen how transactions and locks fit together to provide a robust environment for making changes to your data. The information covered about transactions, locks, and batches carries forward to Chapter 9 and its discussion on stored procedures, which are used in a similar way to batches and are also very useful for encapsulating transactions.

KEY TERMS

• Transact -SQL (T-SQL)

• script

• batch

• variable

• scope

• comment

• cursor

• lock

• deadlock

• login

• user

• role