Stack Overflow
Stack Overflow

Questions tagged [bcp]

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. bcp can also be used to bulk-load (=quickly import) data into the database server. The Microsoft and Sybase versions have similar syntax, but can not be used interchangeably.

The bcp utility copies data between an instance of Microsoft® SQL Server™ 2000 and a data file in a user-specified format

1159 questions
-3
votes
1 answer

SQL- BCP Export ORDER BY with UNION ALL

I am trying to do a bcp data export to a CSV file. But I found that the data in my CSV is out of order. So I am trying to add ORDER BY to properly sort in the correct order. I am using UNION ALL to bring in the column headers, however that appears…
heejin ghim
  • 41
  • 7
-3
votes
1 answer

Run BCP without SQL Client

I had a Access database, since the database limit is 2 GB, I am planning to migrate to Azure Database. I need to upload data with the help of BCP but I was wondering how users will be able to use it since they wont have SSMS installed in their PC.…
Renjith R
  • 3
  • 6
-4
votes
1 answer

SQL Query runs fine In Management Studio but will not run under BCP

This query runs fine within Management Studio, but got a few errors when trying to use bulk copy utility. Here is what I am getting... C:\>BCP "SELECT title1, [precinct percent] AS [PrecinctPercent], leader, [leader percent] AS…
user3242661
  • 89
  • 4
  • 12
1 2 3
…
77
78