MCSE Training Kit (Exam 70-229): Microsoft SQL Server(TM) 2000 Database Design and Implementation (Pro Certification)
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."