IF UPDATE test
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