SQL SERVER 快速插入千萬條資料

1. 正常插入：插入非常慢。

declare @count int = 10000000, @index int = 0
begin tran
while(@index < @count)
begin
	insert into OrderTest(ID) values 
	 (ROUND(RAND() * 10000000, 0))
	set @index = @index + 1
end
commit

2.優化插入：插入速度明顯提升。

declare @count int = 10000000, @index int = 0
begin tran
while(@index < @count)
begin
	insert into OrderTest(ID) values
	--1 
	 (ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	--2
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	--3
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	--4
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	--5
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	--6
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	--7
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	--8
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	--9
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	--10
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	,(ROUND(RAND() * 100000000, 0))
	set @index = @index + 100
end
commit

3.總結：一條語句可插入多條資料，以此來加快插入速度。具體原理，待大神們解釋。