T

table aliasing, 286

TABLE (reserved word), 461, 463

TABLE_CATALOG view, 509, 510, 511, 513, 514, 517, 518

TABLE_CONSTRAINTS views

CONSTRAINT_CATALOG view, 517

CONSTRAINT_NAME view, 517

CONSTRAINT_SCHEMA view, 517

CONSTRAINT_TYPE view, 517

INITIALLY_DEFERRED view, 517

IS_DEFERRABLE view, 517

TABLE_CATALOG view, 517

TABLE_NAME view, 517

TABLE_SCHEMA view, 517

TABLE_NAME view, 510, 511, 513, 514, 517, 518

TABLE_PRIVILEGES views

GRANTEE view, 517

GRANTOR view, 517

IS_GRANTABLE view, 517

PRIVILEGE_TYPE view, 517

TABLE_CATALOG view, 517

TABLE_SCHEMA view, 517

tables

columns, 5, 8

creation of, 117–118

described, 5–6

naming, 324

nullability, 13

primary keys, 6–7

rows, 5

viewing, 58

TABLES views

TABLE_CATALOG view, 517

TABLE_NAME view, 517

TABLE_SCHEMA view, 517

TABLE_TYPE view, 517

TABLE_SCHEMA view, 510, 511, 513, 514, 517, 518

TAN() function, 193, 476

templates, 94–96, 114–115

templates folder path, 115

TEMPORARY (reserved word), 463, 465

TERMINATE (reserved word), 465

terminology, changing, 27–29

TEXTPTR() function, 475

@@TEXTSIZE, 469

TEXTSIZE (reserved word), 461

TEXTVALID() function, 475

THAN (reserved word), 465

THEN (reserved word), 461, 463

third normal form — 3NF, 32

thumbtack icon in SQL Server Management Studio, 75

TIME (reserved word), 463, 466

TIMESTAMP (reserved word), 463, 466

@@TIMETICKS, 204, 471

TIMEZONE_HOUR (reserved word), 463, 466

TIMEZONE_MINUTE (reserved word), 463, 466

TO (reserved word), 461, 463

tool windows in SQL Server Management Studio, 75–81

toolbar options in Query Designer tool, 57–58

tools for SQL Server 2000

Books Online, 49

Configure SQL XML Support in IIS option, 49

Enterprise Manager, 49, 50–51

Import and Export Data shortcut, 49

list of, 49

Profiler, 49

Query Analyzer, 49

Reporting Services, 49

Server Network Utility, 49

Service Manager, 49

tools for SQL Server 2005

business Intelligence Development Studio, 73

Database Tuning Advisor, 73

list of, 73–74

Profiler, 73

Report Manager, 73

SQL Computer Manager, 74

SQL Server Books Online, 74

SQL Server Management Studio, 74–96

Tools menu in Query Analyzer, 64

TOP command, 152–154, 451

TOP (reserved word), 461

top sales by territory and subqueries, 293

top values, 152–154

@@TOTAL_ERRORS, 168, 204, 471

@@TOTAL_READ, 168, 204, 471

totals, 219–220

@@TOTAL_WRITE, 204, 471

TRAILING (reserved word), 463, 466

TRAN (reserved word), 461

@@TRANCOUNT, 204, 470

transaction management

locking options, 393–395

overview, 393

TRANSACTION (reserved word), 461, 463

transactions

handling, 456

logs, 255–256

overview, 16

Transact-SQL

ANSI standard, 2

demise of, premature call for, 3–4

described, 1–2

as programming language, 2–3

as query language, 2–3

TRANSLATE (reserved word), 463

TRANSLATION (reserved word), 463, 466

TREAT (reserved word), 466

TRIGGER (reserved word), 461

triggers

creation of, 119

naming, 324

TRIM (reserved word), 463

TRUE (reserved word), 463, 466

TRUNCATE (reserved word), 461

TRUNCATE TABLE statement, 272–273

TSEQUAL (reserved word), 461

TYPE_UDT_CATALOG view, 515

TYPE_UDT_NAME view, 516

TYPE_UDT_SCHEMA view, 516