SQL Server 2000 Stored Procedures Handbook (Experts Voice)

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