Index_T

T

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




Mastering C# Database Programming
Mastering the SAP Business Information Warehouse: Leveraging the Business Intelligence Capabilities of SAP NetWeaver
ISBN: 0764596373
EAN: 2147483647
Year: 2003
Pages: 181

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net