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

BULK INSERT

BULK INSERT is an import-only Transact-SQL statement that is similar in syntax and operation to BCP. BULK INSERT is faster than BCP and DTS, thus making it very appealing for those operations that require maximum performance.

Use the following syntax to perform BULK INSERT operations:

BULK INSERT [['database_name'.]['owner'].]{'table_name' FROM data_file} 
[WITH
([switch1 parameter1] [switch2]
...
[switch10 parameter10]
...)

where 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.
table_name	Name of the table or view being accessed.
datafile	The name of the data ...