ACID properties, transactions, 82
atomicity, 82
consistency, 82
durability, 82
isolation, 82
actions
triggers and, 203
ordering trigger actions, 208
administration and stored procedures, 120
performance tuning, 120
AFTER trigger, 198, 206
cascading triggers, 210
compared to INSTEAD OF trigger, 209
complex AFTER trigger, 208
CREATE TRIGGER statement for, 203
description, 206
example of using, 207
ordering trigger actions, 208
replaces FOR trigger, 206
transactions, 207
ALTER DATABASE command
CURSOR_DEFAULT setting, 67
scope for cursor, 67
ALTER PROCEDURE statement
breaking encrypted stored procedures, 241
modifying stored procedures, 19
alternate cursor syntax, 70
variable based cursors, 70
application logic
error handling, 52
atomicity
ACID properties, 82
Auto Rollback option
SQL Server Debugger, 60
AVG() function, 180