304 Part I EXAM PREPARATION REVIEW BREAK XML
304 Part I EXAM PREPARATION REVIEW BREAK XML in Review XML is a feature that is very well covered by the exam, so be sure to use the examples here and get a good understanding of OPENXML and how the path syntax works. . XML is a document format that can be used to transfer hierarchical data between systems. . XML documents can be created with the FOR XML clause of the SELECT statement. This clause provides several options for formatting XML output. . You can create rowsets from XML documents using the OPENXML statement. Spend some time typing in the examples from this chapter, or use the slightly more complex examples found in blogs Online to get a complete idea of how the OPENXML and FOR XML ideas really work. IMPORTING AND EXPORTING DATA . Import and export data. Methods include the bulk copy program, the Bulk Insert Task, and Data Transformation Services (DTS). Outside of XML-land, moving data around is pretty simple. There are three major ways to do import/export tasks in SQL Server. They all have strengths and weaknesses. The Bulk Copy Program (BCP) is probably the hardest to learn, but it is also extremely capable and almost ludicrously fast. The BULK INSERT statement implements part of BCP inside SQL Server, so it has all the speed of BCP with an easier-to-use interface. Finally, the Data Transformation Services, or DTS, provide a lot of flexibility and capabilities in a very graphically intensive, point-and-click environment.
For reliable and cheap web hosting services please check cheap web hosting website.