declare @iter int = 0
declare @MaxCustomer int = 1000

while @iter < @MaxCustomer
begin

	declare @FirstName nvarchar(max)
	declare @LastName nvarchar(max)

	select @FirstName = 'John' + convert( nvarchar(max), @iter )
	select @LastName = 'Doe' + convert( nvarchar(max), @iter )

	insert Customer(FirstName, LastName) values ( @FirstName, @LastName)

	select @Iter = @iter + 1

end
Advertisements