SQL Server 2000 Stored Procedures Handbook (Experts Voice)

firing triggers on INSERT or UPDATE action, 205

IF…ELSE decision processing

flow control of stored procedures, 22

immediate update subscriber

nested trigger option, 214

replication, 214

implicit transactions, 88

compared to explicit transactions, 88

in-built functions, 180

AVG() function, 180

COUNT() function, 180

GETDATE() function, 180

inspecting with Query Analyzer, 180

ISNULL() function, 180

scalar valued functions, 186

TABLE data type, 192

index

creating index using deterministic function, 183

indirect recursion triggers, 215

example, 215

INSERT action

firing triggers, 205

inserted table

conceptual tables for triggers, 204

INSTEAD OF trigger, 198, 209

assigning to views, 209

compared to AFTER trigger, 209

CREATE TRIGGER statement for, 203

description, 209

INT data type

using in stored procedures, 31

intent locks, 94

INTO clause

FETCH statement, 71, 72

ISNULL() function, 180

isolation

ACID properties, 82

isolation levels

READCOMMITTED, 98

READUNCOMMITTED, 98

REPEATABLEREAD, 98

SERIALIZABLE, 13, 98

SQL Server concurrency controls, 96

syntax, 98