Appendix E -- Advanced Query Techniques

About This Appendix

This appendix adds to the query techniques described in Appendix D, "Querying Multiple Tables," and Appendix C, "Performing Basic Queries." Subqueries make it possible to use queries inside of other queries to create calculated values and specify advanced selection criteria. Cursors are used to perform row-based processing on SQL result sets. The final lesson explains how to use the techniques, which you have learned to use with SELECT queries, when modifying data.

Before You Begin

To complete the lessons in this appendix, you must:

• Have installed SQL Server 7.0.
• Be able to log on SQL Server with Administrator rights.
• Know the basics of SQL syntax (Appendix C, "Performing Basic Queries," covers basic SQL queries, including exercises).



• Have installed the Exercise files from the Supplemental Course Materials CD-ROM to your hard disk drive. See the "Getting Started" section in "About This Book" for installation instructions.
• Complete the exercises in Appendix D or run the C:\SQLDW\Exercise\bldlib\bldlib.CMD batch file with an appendix parameter of E.