table data type, 67
table variables, 76-77
tables
changing the structure of, 26
viewing and editing, 23-25
table-valued functions, 104-105
TbDbScript, 516-517
TbDir2Vss.vbs, 517
TCP/IP, 5
temporary stored procedures, 223-224
See also global temporary stored procedures
temporary views, 234-237
timestamp data type, 64
optimistic locking using timestamp values, 443-446
tools
Books OnLine (BOL), 12-13
Configuration Manager, 3-6
help, 12-13
Management Studio, 6-11
Profiler, 12
SQLCMD utility, 11-12
trace windows, 490
traffic, 49
transaction managers, 390-391
transactions, 155
autocommit, 155-157
benefits of new transaction paradigm, 424
distributed, 173-175, 420-422
explicit, 157-158, 423-424
implicit, 158-159
locking, 169-173
named, 165
nested, 160-164, 420
problems, 175-178
savepoints, 165-168
transaction isolation levels and hints, 170-173
transaction management in triggers, 291-292
transaction processing architecture, 159-160
TransactionScope class, 417-419
Transact-SQL. See T-SQL
triggers
After, 262-264, 267-270, 272-274
aggregates, 296-298
cascading deletes, 294-296
CLR, 372-383
DDL, 279-283
Delete trigger, 297-298
deleting, 287
design recommendations, 289-291
disabling, 288
DML, 262-278
enforcing schema integrity on different servers or databases, 299-301
and identity values, 460-462
Instead-of, 262, 274-275
listing, 285
managing, 283-288
modifying, 287-288
naming conventions, 633
nested, 272
order of execution, 278
recursive, 272
renaming, 288
rollback of, 497
transaction management in, 291-292
Update trigger, 298
using, 292-293
viewing, 285-287
on views, 275-278
Try-Catch statement, 186-187
deadlocks, 194-198
error handling architecture, 199
with explicit transactions, 191-194
functions of the Catch block, 190-191
nesting, 198-199
what errors are trapped, 187-189
See also error handling
TSEqual() function, 446
T-SQL
batches, 144-151
vs. CLR table-valued functions, 372
cursors, 92-95
Debugger, 476-480
detaching and reattaching databases, 521-522
identifiers, 52-53
managing triggers, 284-288
scripts, 152-154
transactions, 155-178
user-defined data types, 67-68
variables, 68-77
two-phase commit, 173