|
|
icon files, 163
ID directive, 572
ID property
for forms, 522
for Label controls, 528
IDENTITY clause, 128
identity columns
generating, 351
retrieving values of, 384-386
Identity field, 52
@@IDENTITY function, 118, 125
Identity Increment field, 52
Identity Seed field, 52
IDREF directive, 572
IDREFS directive, 572
IF keyword, 97-98
Ignore duplicate key option, 55
Ignore value, 319
IgnoreSchema value
in XmlReadMode, 326
in XmlWriteMode, 323
IIS (Internet Information Server)
installing, 518
XML support for, 586-590, 586-590
IIS Virtual Directory Management for SQL Server console, 586-587, 586, 590
Image controls, 525
image type in SQL Server, 43, 269
Image value in SqlDbType, 241
ImageButton controls, 525
images, functions for, 107
Implementation property, 600
ImportNode method, 602
IN operator, 68-69, 69
Index column for transaction locks, 503
Index Filegroup field, 55
Index Results window, 24, 24
Index tab, 24
Index window, 24
indexes
creating, 55-56, 55, 90-91
for DataRowView objects, 463
for documentation, 24, 24
dropping, 91
in Northwind database, 41-42, 42
InferSchema value, 326
infinity sign for relationships, 40
InfoMessage.cs program, 198-200
InfoMessage event, 189, 198-200
InitializeComponent method, 161, 524
inline table-valued functions, 119, 121-122
InnerText property, 600
InnerXml property, 600
INSERT permission, 38
INSERT statement, 62, 82, 83
with browsers, 592, 592
with ExecuteNonQuery, 230-233
integrity with, 85-86
multiple, 286-288
Insert Table dialog box, 546, 547
InsertAfter method, 602
InsertBefore method, 602
InsertCommand property
in DataAdapter, 373-374, 391, 398
setting, 391
in SqlDataAdapter, 294, 339
InsertProductTrigger.sql script, 129-131
instances, Query Analyzer for, 60, 60
int type in SQL Server, 43, 51, 268-269
Int value in SqlDbType, 241
Int16 type, 269
Int32 type, 268
Int64 type, 268
integrity of databases, 85-86
Intent exclusive (IX) locking mode, 501
Intent shared (IS) locking mode, 501
internal access modifier, 161
Internet Information Server (IIS)
installing, 518
XML support for, 586-590, 586-590
IS (Intent shared) locking mode, 501
IS NULL operator
with joins, 81
working with, 70, 70
IsAliased property, 219
IsAutoIncrement property, 219
IsClosed property, 260
IsContactNameNull method, 337, 414
ISDATE function, 118-119
IsDBNull method
in DataReader, 281
in SqlDataReader, 262
IsEdit property, 461
IsExpression property, 219
IsHidden property, 220
IsIdentity property, 219
IsKey property, 219
IsLong property, 220
IsNew property, 461
ISNULL function, 118-119
IsNull method, 349
IsNullable property, 243
ISNUMERIC function, 118-119
isolation levels for transactions, 492-500, 495
IsolationLevel enumeration, 493
IsolationLevel property, 486
IsPostBack property, 534
IsPrimaryKey property, 418
IsReadOnly property, 600
IsReadOnly value, 220
IsRowGuid field, 53
IsRowVersion property, 219
IsUnique property, 219
Italic property, 538
Item Templates editor, 546, 546
ItemArray property, 348
Items property, 528
IX (Intent exclusive) locking mode, 501
|
|