Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition

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_name	Name of the database being accessed. Database name is optional; if the database name is omitted, the user's default database is used.
owner	Owner 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_name	Name of the table or view being accessed.
TIP Use the # or ## symbol to copy a temporary table.
query	SQL statement that generates a ...