USE [TutorialDatabase] GO DECLARE @Record INT SET @Record=1 WHILE @Record<=10000 BEGIN INSERT INTO [TutorialDatabase].[dbo].[Project] ([Code], [Name], [BeginDate], [EndDate]) VALUES ('PROJ_' + cast(@Record as nvarchar), 'Project ' + cast(@Record as nvarchar), getdate(), null) SET @RECORD = @RECORD+1 END GO