DECLARE @Test	TABLE(
	col0	int,
	col1	varchar(15),
	col2	datetime);

DECLARE @int	int,
		@param1	varchar(15),
		@param2	datetime2,
		@i		int

SET @int = 1
SET @param1 = 'MyTest'
SET @param2 = SYSDATETIME()

While @int <= 100000
Begin
	INSERT INTO @Test(Col0, col1, col2) VALUES( @int,@param1, GETDATE())--@param2)
	Set @int=@int+1
End ;

SELECT DATEDIFF( MCS, @param2, SYSDATETIME())
--You could show the results but it's time consuming
--SELECT * FROM @Test 
DELETE @Test --This would be out of our test

SET @param2 = SYSDATETIME();

WITH Tally(n) AS(
	SELECT ROW_NUMBER() OVER( ORDER BY (SELECT NULL))
	FROM master.sys.all_columns a, master.sys.all_columns b)
INSERT INTO @Test(Col0, col1, col2) 
SELECT n, @param1, GETDATE()
FROM Tally 
WHERE n <= 100000

SELECT DATEDIFF( MCS, @param2, SYSDATETIME())
--Once again, you could show the results but it's time consuming
--SELECT * FROM @Test