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