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
@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