O'Reilly logo

Microsoft® SQL Server™ 2000 DBA Survival Guide, Second Edition by Mark Spenik, Orryn Sledge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required