R

RAID. See Redundant array of inexpensive disks (RAID)
RANK function, 162
Ranking functions, 162
Raw file, 78
RDBMS. See Relational database management system (RDBMS)
RDO. See Remote Data Objects (RDO)
RDS, 122
Read method, 133
Real datatype, 103, 210
Recommendations, 6768
Recommendations tab, 6667
Recordset object, 126127, 129
Recovery model, 158
Redundant array of inexpensive disks (RAID), 112
Referential integrity, 284
Registered Servers, 4447
Relational data
convert, to XML format, 167172
query, using XQUERY, 174176
reading, 165174
Relational database, power of, 12
Relational database management system (RDBMS), 111
Relational format, convert XML data to, 172174
Relationships
add, 9596
defined, 92, 98
use, to perform deletions, 255256
See also entries for specific relationship types
Reliability, 8182
Remote Connections configuration, 28
Remote Data Objects (RDO), 127
Remote instance, query data from, 185
REPLICATE function, 159
Replication, 7879
Reporting Services, 2324
Reports tab, 6667
Represent date, 145
Requirements
defined, 7476
functional, 7476
interview, 75
operational, 74
shadow, 76
write, 76
write user surveys, 7475
Reserved word, 151
Reset method, 213
Response time, 80
Results Pane view, 166
RETURN, 192
RETURN clause, 165
REVERSE function, 159
RIGHT function, 159
RIGHT JOIN, 154155
RIGHT OUTER JOIN, 155
Right padding, 104
Root method, 212
@@ROWCOUNT function, 161
Row insertion, use special values, 223224
ROW_NUMBER function, 162
Rowversion, 107


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