Using the BULK INSERT Statement : BULK INSERT « Insert Delete Update « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Insert Delete Update
  3. BULK INSERT
7> CREATE TABLE tTypes(
8>   TypeID         int            NOT NULL PRIMARY KEY,
9>   ManufacturerID int            ,
10>   TypeName       char (20)      NOT NULL,
11>   GrossWeight    numeric (10,1) NOT NULL
12> )
13>  GO
1> BULK INSERT tTypes
2>  FROM 'C:\Types.txt'
3>  WITH
4>   (CHECK_CONSTRAINTS)
5> GO
Msg 4860, Level 16, State 1, Server J\SQLEXPRESS, Line 1
Cannot bulk load. The file "C:\Types.txt" does not exist.
1>
2> --The default field delimiter is the tab character.
3>
4> drop table tTypes
5> GO
1>








2.3.BULK INSERT
2.3.1.Using the BULK INSERT Statement