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



    EXAM CRAM 2 Designing and Implementing Databases with SQL Server 2000 Enterprise
    MCAD/MCSE/MCDBA 70-229 Exam Cram 2: Designing & Implementing Databases w/SQL Server 2000 Enterprise Edition
    ISBN: 0789731061
    EAN: 2147483647
    Year: 2005
    Pages: 154

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net