T

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