O'Reilly logo

Pro SQL Server 2008 XML by Michael Coles

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required