O

Object attributes, 99108
Object Explorer
stored procedures actions in, 52
table modification and script generation in, 49
use in SQL Server Management Studio, 4753
Object-linking and embedding database (OLE DB)
defined, 121122
providing generic access to database system, 1011
understanding, 126127
use SQL Server Integration Services (SSIS), 78
Object-Oriented Systems Model (OSM), 92
Object-Role Modeling (ORM), 92
ODBC. See Open database connectivity (ODBC)
ODBC Microsoft SQL Server Setup dialog box, 125
OLE DB. See Object-linking and embedding database (OLE DB)
One-to-many relationships, 9593
Online index operations, 68
Open, 131
Open database connectivity (ODBC), 11
create data source name , 123125
main components of database application connecting to SQL Server 2005 through, 10
program applications, 125126
providing generic access to
database system, 1011
SQL Reporting Services, 79
Open database connectivity (ODC), 121124
OpenXML, 174
Operational requirements
architecture and, 77
availability, 7778
defined, 74, 76
examples, 7677
interoperability, 7879
manageability, 7980
performance, 8081
reliability, 8182
scalability, 82
security, 83
See also Requirements
Operation system requirements, 1516
Operator precedence, 146
Optimistic concurrency, 261265, 281
Oracle, 7879
Oracle ODBC, 122
ORDER BY clause, 162, 176177
ORM. See Object-Role Modeling (ORM)
OR operator, 145146
OSM. See Object-Oriented Systems Model (OSM)
Other Data Sources node, 287
OUT clause, 165
Output parameters, 164165


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