Chapter 6 -- Accessing and Modifying Data

3 4

Chapter 6

Accessing and Modifying Data

About This Chapter

The primary purpose of a SQL Server database is to store data and then make that data available to authorized applications and users. You can access and change data by using an application or utility to send data retrieval and modification requests to SQL Server. For the purpose of this training kit, you will use SQL Query Analyzer as your primary tool to access and modify data in a SQL Server database. SQL Query Analyzer enables you to submit Transact-SQL statements that you can use to retrieve and modify data. You can implement most of these operations by using one of four Transact-SQL statements: SELECT, INSERT, UPDATE, or DELETE. This chapter provides detailed information about each of these statements and describes how you can use each statement to retrieve and modify data. This chapter also introduces you to other methods for adding, modifying, and deleting data.

Before You Begin

To complete the lessons in this chapter, you must have:

• SQL Server 2000 Enterprise Edition installed on a Windows 2000 Server computer.
• The ability to log on to the Windows 2000 Server computer and to SQL Server as the Windows 2000 Administrator.