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