Creating a large table with random data in sql

create table demotable (productid int,productname varchar(50))    

declare @id int
select @id =1
while (@id<=300)
begin
insert into demotable values (@id,'product'+cast(@id as nvarchar(50)))
select @id=@id+1
end

select * from demotable

drop table demotable