SQL Server 2000 Stored Procedures Handbook (Experts Voice)

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