Top "Bcp" questions

The bulk copy program `bcp` is a command line tool that can be used to export data from Microsoft® SQL Server™ or SAP Sybase Adaptive Server Enterprise databases to a data file in a user-specified format.

Export table to file with column headers (column names) using the bcp utility and SQL Server 2008

I have seen a number of hacks to try to get the bcp utility to export column names along with …

sql-server csv header bcp
How to export SQL Server 2005 query to CSV

I want to export some SQL Server 2005 data to CSV format (comma-separated with quotes). I can think of a lot …

sql-server sql-server-2005 bcp sqlcmd
How to export data from SQL Server 2005 to MySQL

I've been banging my head against SQL Server 2005 trying to get a lot of data out. I've been given a …

mysql sql-server csv sql-server-2005 bcp
Unable to open BCP host data-file

Below is an example of the BCP Statement. I'm not accustomed to using BCP so your help and candor is …

sql sql-server bcp
Use bcp to import csv file to sql 2005 or 2008

I have a csv file and i need to import it to a table in sql 2005 or 2008. The column names …

sql sql-server-2005 tsql sql-server-2008 bcp
Using bcp utility to export SQL queries to a text file

I debug a stored procedure (SQL Server 2005) and I need to find out some values in a datatable. The procedure …

sql sql-server debugging sql-server-2005 bcp
bcp: Error = [Microsoft][SQL Server Native Client 10.0]String data, right truncation

I have recently encountered an error while working with bcp. Here is the error. SQLState = 22001, NativeError = 0 Error = [Microsoft][SQL Server …

sql-server-2008 sql-server-2008-r2 bcp
Unexpected EOF encountered in BCP

Trying to import data into Azure. Created a text file in Management Studio 2005. I have tried both a comma and …

sql azure bcp
What is the best way to save XML data to SQL Server?

Is there a direct route that is pretty straight forward? (i.e. can SQL Server read XML) Or, is it …

sql-server xml ado.net etl bcp
SQLState = S1000, NativeError = 0

I am getting this Error While I try to do BCP SQLState = S1000, NativeError = 0 Error = [Microsoft][SQL Server Native Client 11.0]…

sql-server-2012 bcp