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