Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition

Summary

This chapter provides you with the basic tools for performing the most common SQL commands. You have learned how to retrieve rows in many different formats using the SELECT statement as well as how to add, update, and delete rows in tables using the INSERT, UPDATE, and DELETE statements, respectively. You have also learned how to create a new table using either the CREATE TABLE or SELECT...INTO statements. You should take the time to try out the commands described here until you feel you have a good understanding of how they work and review the examples found in SQL Server Books On-Line as well or buy other books from SAMS publishing that focus on SQL. You should also become familiar with as many of SQL Server's built-in functions as ...