Cascade Delete relationships, 259
Character datatype, 103105
Char datatype, 99, 103105
CHECK constraints, 108, 110, 116
Choose A Destination page, 232
Client applications, views within, 186188
CLR. See Common language runtime (CLR)
CLR Code Access Security permission, 217
CLR UDFs. See Common language runtime user -defined functions (CLR UDFs)
CLR UDTs. See Common language runtime-based UDTs (CLR UDTs)
Code, using monolithic application with data embedded in, 7
Collation Settings dialog box, 24
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 object, 126128, 249, 284285
CommandType property, 132
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
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
Configure Flat File Destination page, 233
Connection object, 126128, 249, 284285
Connection Properties, 46
Connection string, 127128
Connect To Database Engine dialog box, 57
Connect To Server dialog box, 84
CONVERT function, 160, 275
Cost. See Transaction cost analysis
Create A New Data Source To SQL Server dialog box, 123
Create New Data Source dialog box, 123
CREATE VIEW statement, 179, 182183
CURRENT_USER function, 159
CURSOR_STATUS function, 157