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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.