USE DB02

DECLARE @Count int = 10000
DECLARE @n int

SET @n = 1

WHILE @n < @Count
BEGIN	
	INSERT INTO Table1(Name)
	VALUES ('Name' + cast(@n as nvarchar(10)));

	WAITFOR DELAY '00:00:05';	
	SET @n = @n + 1
END;