Export SQL Server 2005 Xml Column Data to Xml File


Xml data stored using the SQL Server 2005 xml data type can be exported a number of ways and you can obviously write a managed stored procedure to do it. However for a quick, one off, type¬†approach you can use the BCP command. The downside of this is that, given the command above you’ll get … Continue reading Export SQL Server 2005 Xml Column Data to Xml File