I

IBM, 78

IDENT_CURRENT, 243

IDENT_CURRENT function, 161

Identifier, 157

IDENT_INCR function, 161

@@IDENTITY function, 161, 243

IDENT_SEED function, 161

IEnumerable interface, 212213

IEnumerator interface, 212213

IF, 192

Import data, 228230

Include Client Statistics, 5556

Index, 68

INDEX_COL function, 158

Index seek operation, 148149

In-Line user defined functions (in-line UDF), 197199

INNER JOIN syntax, 151153, 258

Input parameter, 173174

INSERT, 133, 136, 184

Insert operations, 241243

INSERT statement, 241

create, with SQL Management Studio, 221223

use other forms of, 224225

use special values for row insertion, 223224

INSERT trigger, 243

Installation Wizard dialog box, 20

INSTEAD OF DELETE trigger, 257258

INSTEAD OF INSERT trigger, 227228

INSTEAD OF trigger, 185, 243

INSTEAD OF UPDATE trigger, 277278

Int datatype, 101, 209

Integer columns , 100

Integer datatype parameters, 101

Integers, 100101

Integration Services, 231241

Internet applications, 82

Interoperability, 7879, 129

Intersection relationship, 9694

Interview, 75

@@IO_BUSY function, 161

IP address, 34.

See also Transmission Control Protocol/Internet Protocol (TCP/IP)

IsDeterministic attribute, 211

IS_MEMBER function, 159

ISNULL function, 161, 193

IS_SRVROLEMEMBER function, 159