INSERT INTO pantscolor_t (procode, color, pic)
VALUES
('74251', 'Black', '511black.jpg'),
('74251', 'OD Green', '511odgreen.jpg'),
('74251', 'Black', '511black.jpg'),
('74251', 'OD Green', '511odgreen.jpg'),
('74251', 'Black', '511black.jpg'),
('74251', 'OD Green', '511odgreen.jpg'),
..........
..........
..........
INSERT INTO pantscolor_t (procode,color,pic)
VALUES
('74251', 'Charcoal', '511charcoal.jpg'),
('74251', 'Charcoal', '511charcoal.jpg'),
('74251', 'Charcoal', '511charcoal.jpg'),
('74251', 'Charcoal', '511charcoal.jpg'),
.............
.............
.............
INSERT INTO........................
INSERT INTO........................
INSERT INTO........................
INSERT INTO........................
我有100000行数据,但是我的插入语句超过了1000行。当我在SSMS中运行SQL语句时,出现错误:
插入语句中的行值表达式数量超过了最大允许的1000个行值。
bcp.exe
:bcp mytable in data.txt -S (local) -d mydatabase -T -c
(-T 表示使用可信连接,-c 表示字符数据,适用于制表符分隔的文件。你可以通过bcp --help
查看其他选项,例如使用 -t 来指定字段分隔符,-r 来指定行分隔符,以防数据不是以制表符分隔或制表符分隔)。 - endo64