BCP Syntax

Use the following syntax to perform BCP operations:

bcp [[database_name.]owner.]table_name | "query" {in | out | format | queryout} datafile 
[switch1 parameter1] [switch2]
...
[switch10 parameter10]
...

in which the following are the parameters:

database_nameName of the database being accessed. Database name is optional; if the database name is omitted, the user's default database is used.
ownerOwner of the table or view being accessed.

TIP

Use the .. symbol to specify ownership. The .. syntax is more generic than specifying an owner (for example, pubs..authors instead of pubs.dbo.authors).
table_nameName of the table or view being accessed.

TIP

Use the # or ## symbol to copy a temporary table.
querySQL statement that generates a ...

Get Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition now with O’Reilly online learning.

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