Solid Quality Learning, Microsoft Corporation Staff - Microsoft SQL Server 2005 Database Essentials Step by Step

2017-07-07 02:10:07

TableAdapter class, 136138

Table Adapters, 285289

Table adapters

create, 285287

use stored procedures in, 289296

Table alias, 170172

TableDefinition, 213

Table name , 150

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

Tables note, 4849

Table-valued UDF, 200202, 212216

TCP/IP. See Transmission Control Protocol/Internet Protocol (TCP/IP)

TCP port, 3536

Template Explorer, 57

Templates, 5758

Test, 8485, 104

Text datatype, 105

Three- tier application design, 12

Throughput, 80

Timestamp column, 261264

Timing procedure, 212

Tinyint datatype, 101, 209

TOP clause, 184

Trace, create, 5962

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 log, 112

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

Transformation, 239

Transmission Control Protocol/Internet Protocol (TCP/IP), 3435, 39

Triggers, 265266, 282283.

Категории