Scripts, Batches, and Transactions
Scripts
Batches
Working with Variables
Naming Variables
Declaring Variables
Variable Types
Variable Scope
Setting and Using Variables
Global Variables
Comments
Statement Blocks with BEGIN...END
Conditional Statements and Branching with IF...THEN...ELSE
WHILE loops
Managing Result Sets by Using Cursors and Transact- SQL
Concurrency and Locking
Lock Contention
Deadlocks
Isolation Levels
Lock Granularity
Enforcing Procedural Business Logic Using Transactions
Designing and Managing Transactions
Managing Control of Flow with Transactions
Raising User-Defined Errors
System and User Error Messages
Raising Errors
Managing Data Manipulation Using Transactions
Implementing Security
The SQL Server Login/User Model
Statement Permissions
Object Permissions
User Roles
Application Roles
Apply Your Knowledge
Exercises
Review Questions
Exam Questions
Answers to Review Questions
Answers to Exam Questions