Writing from SQL Server table to file using BCP

Question

I just realized my caps was on from working in SQL Server, ha.

Anyways, Im trying to write from

serverName.databaseName.databaseInstanceName.TableName

to

C:\FileName.xml

using bcp and I want to write only columns Col1 and Col2, could I get a little syntax help? I'm struggling over here.

Thanks,

Ted

I did google it but my search terms were off... I got some better info this time. I'll post my result for future SO reference once ive got it working. — tb.
– tb., Commented Sep 25, 2009 at 15:31

Lukasz Lysik · Accepted Answer · 2009-09-25 15:31:10Z

1

In order to create an XML version of the format file the command is identical except we use the -x parameter.

bcp "SELECT col1, col2 FROM AdventureWorks.HumanResources.Department" format nul -c -x -f department.xml -T -S servername

answered Sep 25, 2009 at 15:31

Lukasz Lysik

10.7k4 gold badges53 silver badges73 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

tb. · Accepted Answer · 2009-09-25 18:31:29Z

1

FYI for anyone else....

bcp "Select whatever from dbInstanceName.dbo.tableName" quesryout C:\output.txt -e C:\errors.txt -c -T -S localhost\dbName

answered Sep 25, 2009 at 18:31

tb.

7868 silver badges18 bronze badges