|
|
T-SQL. See Transact-SQL (T-SQL)
Table controls, 526
Table lock type, 501
Table property
in DataColumn, 350
in DataRow, 348
in DataView, 454
in ForeignKeyConstraint, 421
in UniqueConstraint, 418
table type, 44
TableDirect commands, 207, 210-211, 223-225
TableDirect value, 210
TableMapping object, 329
TableMapping property, 402
TableMappingCollection class, 329
TableMappings property, 296, 329
TableName property, 312, 330, 346
tables, 3, 29
aliases for, 78-79, 78
altering, 90
creating, 89-90
dropping, 90
Enterprise Manager for, 51-52, 51-52
integrity of, 85-86
joined
for populating objects, 303-304
retrieving rows from, 79-81, 80
working with, 283-285
mapping, 328-331, 329
names for, 52, 52, 64
relationships in. See relationships
rows in. See rows
in SQL Server, 33, 34
Tables property, 300
templates
in DataList, 545
XML, 593-594, 594
Terms Of Use page, 629, 629
Test Connection option, 92
testing Web services, 621-622, 622-623
Text command type, 210
text functions, 107
Text property
in DataBindings, 179
for DropDownList controls, 529
for Label controls, 528
for RadioButtonList controls, 529
text type, 43, 270
Text value
in CommandType, 210
in SqlDbType, 242
TextBox controls, 165
in Web forms, 524
in Windows forms, 180
time functions, 116-117
TIME keyword, 103
timeouts
for database connections, 190
for transaction locks, 505
timestamp type in SQL Server, 44, 270
Timestamp value in SqlDbType, 242
tinyint type in SQL Server, 43, 270
TinyInt value in SqlDbType, 242
Toolbox, 155-156
Tools menu, 21
TOP keyword, 74, 75
ToString method
in DataView, 455
for ListView controls, 289
@@TRANCOUNT function, 118
Transact-SQL (T-SQL)
CASE statements in, 98-99
comments in, 97
conditional logic in, 97-98
cursors in, 103-107
functions in, 107
aggregate, 107-110, 109-110
date and time, 116-117
mathematical, 111-113
string, 113-116
system, 117-119
user-defined, 119-124, 121, 123-124
GOTO statements in, 101-102
RAISERROR statements in, 103
RETURN statements in, 102
for savepoints, 486-488, 489
stored procedures in, 124-127, 126
for transaction isolation levels, 493-495, 495
triggers in, 127-128
DeleteProductTrigger, 133-134
InsertProductTrigger, 129-131, 130
UpdateUnitPriceProductTrigger, 131-133
variables in, 95-96, 96
WAITFOR statements in, 102-103
WHILE statements in, 99-101
Transaction class, 140, 236
Transaction property
in DataAdapter, 413
in SqlCommand, 208
TransactionIsolation.cs program, 497-500
TransactionIsolation.sql script, 494-495, 495
transactions, 87-89, 236-239, 485
with DataSet objects, 412-413
isolation levels for, 492-500, 495
locks for. See locks for transactions
savepoints for
SqlTransaction objects for, 488-492
T-SQL for, 486-488, 489
SqlTransaction objects for, 140, 236
creating, 237
for isolation levels, 496-500
properties and methods in, 486
for savepoints, 488-492
triggers, 127-128
DeleteProductTrigger, 133-134
InsertProductTrigger, 129-131, 130
UpdateUnitPriceProductTrigger, 131-133
try/catch blocks, 7, 9-10
types
fixed length, 51
in SQL Server, 42-44
in SqlDbType, 241-242
for T-SQL variables, 95
|
|