C

C#, 125, 207208
C++, 11
Capacity, 89
Capacity planning, 83
Cascade, 256
Cascade Delete relationships, 259
CASE, 147148, 177
CAST, 221
CAST function, 160, 275
Chaos Report, 73
Character datatype, 103105
Char datatype, 99, 103105
Check, defined, 183
CHECK constraints, 108, 110, 116
CHECKPOINT, 112
Child entity, 9596
Choose A Destination page, 232
C language, 125
Client applications, views within, 186188
Client Protocols, 3839
Clipper, 9
Close, 131
CLR. See Common language runtime (CLR)
CLR Code Access Security permission, 217
CLR Integration, 18, 41
CLR UDFs. See Common language runtime user -defined functions (CLR UDFs)
CLR UDTs. See Common language runtime-based UDTs (CLR UDTs)
C#.NET, 107
C++.NET, 107
Code, using monolithic application with data embedded in, 7
Code page, 104
Codezone Community, 32
Collations, 104105
Collation Settings dialog box, 24
COL_LENGTH function, 158
COL_NAME function, 158
Column alias, 170171
Column name , 150
Column(s)
assign new values to, 274275
change content of large (BLOB), 276
change content of large (MAX), 276
compare, 261
create, to capture object attributes, 99
Primary Key, 274
use global unique identifier (GUID), 264265
use ModifiedDate, 261
use Timestamp, 261264
value of, violates referential integrity, 284
Columns per index, max, 68
COLUMNS_UPDATED function, 278
COM. See Component Object Model (COM)
Command class, 130
Command object, 126128, 249, 284285
CommandType property, 132
Committed, 112
Common language runtime (CLR), 17, 208
Common language runtime-based UDTs (CLR UDTs), 107108
Common language runtime (CLR) stored procedures, 216217
Common language runtime user-defined functions (CLR UDFs)
and procedures, 207217
statistical calculations, 208216
types used in, 209210
Completing Microsoft SQL Server 2005 Setup dialog box, 2627
Complex attributes, 107108
Component Object Model (COM), 11, 126, 129
Components to Install dialog box, 21
Compressed volume, 112
Conceptual Entity-Relationship (ER) Diagram, 9394
Conceptual model
add attributes, 9495
add relationships, 9596
approve, 98
create, 9293
create entities, 94
defined, 91
diagram, 9394
intersection, 9697
many-to-many relationships, 9697
multi-intersection, 9697
self-referencing, 9697
validate business requirements through, 9298
Configuration function, 157
Configuration Node, 3437
Configure Flat File Destination page, 233
Connection class, 130
Connection object, 126128, 249, 284285
Connection Properties, 46
Connection string, 127128
Connect To Database Engine dialog box, 57
Connect To Server dialog box, 84
Console Root tree, 63
CONSTRAINT, 244
Constraints, 108110
CONTINUE, 192
CONVERT, 221
CONVERT function, 160, 275
COS function, 158
Cost. See Transaction cost analysis
Counter Logs, 63
COUNT function, 156
@CPU_BUSY function, 161
Create A New Data Source To SQL Server dialog box, 123
Create New Data Source dialog box, 123
CREATE VIEW statement, 179, 182183
Criteria pane, 4951
Current property, 213
CURRENT_USER function, 159
Cursor function, 157
CURSOR_STATUS function, 157


Solid Quality Learning, Microsoft Corporation Staff - Microsoft SQL Server 2005 Database Essentials Step by Step
Solid Quality Learning, Microsoft Corporation Staff - Microsoft SQL Server 2005 Database Essentials Step by Step
ISBN: N/A
EAN: N/A
Year: 2006
Pages: 130

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net