海量数据测试

 

declare @i int,
        @num int
set @i=1
set @num=100000000
--set @num=1
while @i<@num
BEGIN
---------------
--INSERT
---------------
set @i=@i+1
END

SELECT COUNT(column_name) FROM TableName