Appendix C -- Performing Basic Queries

About This Appendix

In this appendix, you will learn about basic SQL queries. If you are not familiar with the basic use of the SELECT, INSERT, UPDATE, and DELETE statements, you should read this appendix before you begin Appendixes D, E, or F.

This appendix discusses the following:

  • Using the SELECT statement to retrieve data from one table
  • Using the WHERE clause to limit the rows that are returned by a query
  • Formatting and sorting data in a result set
  • Inserting a row into a table using the INSERT statement
  • Updating rows in a table using the UPDATE statement
  • Deleting rows from a table using the DELETE or TRUNCATE TABLE statements

Before You Begin

To complete the lessons in this appendix, you must

  • Have installed SQL Server 7.0
  • Log in to SQL Server with Administrator permissions
  • Have installed the exercise files from the Supplemental Course Materials CD-ROM to your hard drive using the Setup.EXE discussed in the "Getting Started" section
  • Run the c:\sqldw\exercise\bldlib\bldlib.CMD batch file with an appendix argument of C


Microsoft Corporation - Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit
Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit
ISBN: 0735606706
EAN: 2147483647
Year: 1999
Pages: 114

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