R

RADIANS() function, 193, 476

RAID device, 357–359

RAISERROR (reserved word), 460

RAND() function, 193, 476

RANK() function, 197–198, 477

ranked results, 317

ranking functions

DENSE_RANK() function, 197–198, 477

NTILE(n) function, 199, 477

overview, 196

RANK() function, 197–198, 477

ROW_NUMBER() function, 197, 477

RDBMS. See relational database management systems (RDBMS)

RDO (Remote Data Objects), 402

READ COMMITTED locking option, 394

READ (reserved word), 460, 462

READ UNCOMMITTED locking option, 394

READS (reserved word), 464

READTEXT (reserved word), 460

REAL (reserved word), 462, 464

RECONFIGURE (reserved word), 460

record maintenance, 370

RECURSIVE (reserved word), 464

REF (reserved word), 464

REFERENCES (reserved word), 460, 462

REFERENCING (reserved word), 464

REFERENTIAL_CONSTRAINTS views

CONSTRAINT_CATALOG view, 513

CONSTRAINT_NAME view, 513

CONSTRAINT_SCHEMA view, 513

DELETE_RULE view, 514

MATCH_OPTION view, 514

UNIQUE_CONSTRAINT_CATALOG view, 513

UNIQUE_CONSTRAINT_NAME view, 513

UNIQUE_CONSTRAINT_SCHEMA view, 513

UPDATE_RULE view, 514

relational database management systems (RDBMS)

data integrity, 16–18

described, 5

file-based database products compared, 26

overview, 4

relationships, 13–15

tables, 5–13

relationships

Entity Relationship Diagram (ERD), 15

linking tables, 15

many-to-many relationships, 15

one-to-exactly-one relationships, 15

one-to-many relationships, 14

one-to-one relationships, 14

one-to-zero relationships, 14

overview, 13–14, 29

parent-child relationships, 14

RELATIVE (reserved word), 462, 464

Remote Data Objects (RDO), 402

removing records

DELETE statement, 269–270

multiple tables, deleting records based on, 271–272

overview, 269

TRUNCATE TABLE statement, 272–273

WHERE clause, 270

@@REMSERVER, 469

REPEATABLE READ locking option, 394

REPLACE() function, 191, 479

REPLICATE() function, 191, 479

replication procedures, 496–501

REPLICATION (reserved word), 460

Report Designer in SQL Server Reporting Services, 414–418

report layout, 426–430

Report Manager, 73, 443

report parameters, configuring, 431–436

Reporting Services, 49

reserved words

future reserved words, 464–466

list of, 460–461

ODBC reserved words, 462–464

overview, 459–460

resource pooling, 408–409

RESTORE (reserved word), 460

RESTRICT (reserved word), 460, 462

RESULT (reserved word), 464

results, sorting, 150–152

RETURN (reserved word), 460

RETURNS (reserved word), 465

REVERSE() function, 191–192, 479

REVOKE command, 123, 347

REVOKE (reserved word), 460, 462

RIGHT() function, 185–186

RIGHT (reserved word), 460, 462

ROLE (reserved word), 465

ROLLBACK (reserved word), 460, 462

ROLLUP (reserved word), 465

ROUND() function, 193, 476

ROUTINE (reserved word), 465

ROUTINE_BODY view, 516

ROUTINE_CATALOG view, 515

ROUTINE_COLUMNS views

CHARACTER_MAXIMUM_LENGTH view, 514

CHARACTER_OCTET_LENGTH view, 514

CHARACTER_SET_CATALOG view, 514

CHARACTER_SET_NAME view, 514

CHARACTER_SET_SCHEMA view, 514

COLLATION_CATALOG view, 514

COLLATION_NAME view, 514

COLLATION_SCHEMA view, 514

COLUMN_DEFAULT view, 514

COLUMN_NAME view, 514

DATA_TYPE view, 514

DATETIME_PRECISION view, 514

DOMAIN_CATALOG view, 514

DOMAIN_NAME view, 514

DOMAIN_SCHEMA view, 514

IS_NULLABLE view, 514

NUMERIC_PRECISION view, 514

NUMERIC_PRECISION_RADIX view, 514

NUMERIC_SCALE view, 514

ORDINAL_POSITION view, 514

TABLE_CATALOG view, 514

TABLE_NAME view, 514

TABLE_SCHEMA view, 514

ROUTINE_DEFINITION view, 516

ROUTINE_NAME view, 515

ROUTINES views

CHARACTER_MAXIMUM_LENGTH view, 515

CHARACTER_OCTET_LENGTH view, 515

CHARACTER_SET_CATALOG view, 515

CHARACTER_SET_NAME view, 515

CHARACTER_SET_SCHEMA view, 515

COLLATION_CATALOG view, 515

COLLATION_NAME view, 515

COLLATION_SCHEMA view, 515

CREATED view, 516

DATA_TYPE view, 515

DATETIME_PRECISION view, 515

DTD_IDENTIFIER view, 516

EXTERNAL_LANGUAGE view, 516

EXTERNAL_NAME view, 516

INTERVAL_PRECISION view, 515

INTERVAL_TYPE view, 515

IS_DETERMINISTIC view, 516

IS_IMPLICIITLY_INVOCABLE view, 516

IS_NULL_CALL view, 516

IS_USER_DEFINED_CAST view, 516

LAST_ALTERED view, 516

MAX_DYNAMIC_RESULT_SETS view, 516

MAXIMUM_CARDINALITY view, 516

MODULE_CATALOG view, 515

MODULE_NAME view, 515

MODULE_SCHEMA view, 515

NUMERIC_PRECISION view, 515

NUMERIC_PRECISION_RADIX view, 515

NUMERIC_SCALE view, 515

PARAMETER_STYLE view, 516

ROUTINE_BODY view, 516

ROUTINE_CATALOG view, 515

ROUTINE_DEFINITION view, 516

ROUTINE_NAME view, 515

ROUTINE_SCHEMA view, 515

ROUTINE_TYPE view, 515

SCHEMA_LEVEL_ROUTINE view, 516

SCOPE_CATALOG view, 516

SCOPE_NAME view, 516

SCOPE_SCHEMA view, 516

SPECIFIC_CATALOG view, 515

SPECIFIC_NAME view, 515

SPECIFIC_SCHEMA view, 515

SQL_DATA_ACCESS view, 516

SQL_PATH view, 516

TYPE_UDT_CATALOG view, 515

TYPE_UDT_NAME view, 516

TYPE_UDT_SCHEMA view, 516

UDT_CATALOG view, 515

UDT_NAME view, 515

UDT_SCHEMA view, 515

ROUTINE_SCHEMA view, 515

ROUTINE_TYPE view, 515

ROW (reserved word), 465

row-based operations, 109

@@ROWCOUNT, 204, 470

ROWCOUNT (reserved word), 460

ROWCOUNT_BIG() function, 201, 482

ROWGUIDCOL (reserved word), 460

ROW_NUMBER() function, 197, 477

rows

from another table, inserting, 261–262

ordering, 356–357

overview, 5

ROWS (reserved word), 462, 465

rowset versus cursor operations, 296–297

RTRIM() function, 190–191, 479

RULE (reserved word), 460

Russell, Robert (Consensus Soundex), 302