Chapter 7 -- Managing and Manipulating Data

3 4

Chapter 7

Managing and Manipulating Data

About This Chapter

In Chapter 6, "Accessing and Modifying Data," you learned how to view and modify data in a SQL Server database. In this chapter, you will learn more techniques for managing and manipulating data, including how to import and export data, how to manipulate heterogeneous data, how to use Transact-SQL cursors, and how to extract data in Extensible Markup Language (XML) format.

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.
• Completed the exercises in Chapter 3, "Designing a SQL Server Database," Chapter 4, "Implementing SQL Server Databases and Tables," and Chapter 5, "Implementing Data Integrity."