EXAM CRAM™ 2 Designing and Implementing Databases with SQL Server 2000 Enterprise Edition [Electronic resources] نسخه متنی

Chapter 5. Retrieving and Modifying Data

Terms you'll need to understand:

BCP

DTS

OPENXML

SELECT

WHERE

GROUP BY

HAVING

ORDER BY

COMPUTE

XML

Schema

Cursor

Lock

INTO

INSERT

DELETE

UPDATE

Techniques you'll need to master:

Importing and exporting data

Manipulation of data from various sources

Data retrieval, filtering, grouping

Summarizing data

Data modifications

Utilizing XML options