The Bulk-Copy Program

The proper usage of BCP is

bcp {dbtable | query} {in | out | queryout | format} datafile

followed by one or more switches.

In this syntax,

						dbtable

is the database_name + owner + table_name|view_name (for example, Northwind.dbo.customers or “Northwind.dbo.customers”):

						database_name

is the name of the database in which the specified table or view resides. If not specified, this is the default database for the user.

						owner

is the name of the owner of the table or view.

						table_name | view_name

is the name of the destination table or view when copying data in to SQL Server (in), and the source table when copying data from SQL Server (out).

query

is a Transact-SQL query that returns a resultset. queryout must also be ...

Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial