TableAdapter class, 136138
Table adapters
create, 285287
use stored procedures in, 289296
Table(s)
change row information in, 260
create, 9899, 115116
data to be deleted related to other, 267268
designing user -defined functions, 163164
mix data from, 186
query more than one, 5052
select data from multiple, 149155
select data from single, 143149
use more than two, 151152
use T-SQL to create, 116
Table-valued UDF, 200202, 212216
TCP/IP. See Transmission Control Protocol/Internet Protocol (TCP/IP)
Three- tier application design, 12
Tinyint datatype, 101, 209
Trace Properties dialog box, 6062, 8485
Transaction cost analysis
calculate cost of average profile, 8889
calculate maximum capacity, 89
compiling user profile, 84
defined, 83
execute discrete tests, 8485
measure cost of each operation, 8588
verify maximum capacity, 89
Transaction process, 111112
Transact SQL language, 207208
Transact-SQL (T-SQL), 4849, 192
create database schemas using, 115
create database using, 114
create tables using, 116
create view using, 181
defined, 67
updated columns , 278
Transmission Control Protocol/Internet Protocol (TCP/IP), 3435, 39
Triggers, 265266, 282283.
See also individual types of triggers
T-SQL. See Transact-SQL (T-SQL)
T-SQL user-defined datatypes, 107
Tuning Advisor, 6568, 149