Chapter 14. XML Support title
In addition to SQL Server 2008's built-in XML support, there are many development, support, and administration tools designed to take advantage of XML. Many of them come standard with SQL Server, while others are third-party applications. In this chapter, I will give a brief overview of some of the more useful XML-based tools and utilities available.
Bulk Copy Program
The Bulk Copy Program, or BCP for short, is SQL Server's command-line tool for bulk loading data from flat files into SQL Server tables. BCP can use XML format files to specify the format, data types, and flat file-to-database column mappings. BCP can generate XML format files automatically from the command line, with the format and -x command-line options, ...
Get Pro SQL Server 2008 XML now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
