62,046
社区成员
发帖
与我相关
我的任务
分享
c盘文件:
1,DSJ-120,电视机,1865.00,15
2,DSJ-180,电视机,2073.00,10
3,XYJ-13,洗衣机,486.00,20
4,XYJ-20,洗衣机,873.00,12
5,DBX-134,电冰箱,1456.00,8
6,DSJ-340,电视机,3726.00,5
7,WBL-6,微波炉,640.00,10
8,KTQ-12,空调器,2800.00,12
SQL:
CREATE TABLE TESTBLUK
(
TID INT PRIMARY KEY,
TCODE VARCHAR(200),
TNAME varchar(100),
PRICE DECIMAL,
TCOUNT INT
)
BULK INSERT TESTBLUK FROM 'c:\Demo.txt' WITH (FIELDTERMINATOR = ',',ROWTERMINATOR = '\n')