LOCAL scope
reasons for preferring, 81
scope for cursor, 67
locks
blocking, 94
deadlocks, 95
hints for locks, 95
optimistic locking, 101
pessimistic locking, 100
SQL Server concurrency controls, 93
table of lock modes, 94
table of lock types, 93
transactions and, 108
logic
encapsulating logic in stored procedures, 112
logical unit of work, optimistic locking, 101, 106
description, 106
example, 106
login ID's
permissions issues, 224
sysxlogins table, 224
loops
flow control of stored procedures, 25
WHILE loop, 25