sql - 如何在SQL Server中插入100000行？

Question

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语句时，出现错误:

The number of row value expressions in the INSERT statement exceeds the maximum allowed number of 1000 row values.

Answer 1

创建csv文件(或具有定义的字段定界符和行定界符的某些文件)，然后使用“批量插入”选项将文件加载到数据库。文件可以有100000行；使用批量上传来加载大文件不会有任何问题。

http://msdn.microsoft.com/en-us/library/ms188365.aspx