Insert thousand record at a time

alter procedure Insert100rows
  as begin
  declare @id int
select @id = 1
while @id >=1 and @id <= 1000
begin
    insert into HardwareDbTable(AssetName,Manufacturer,Model) values('jack' + convert(varchar(5), @id), 'dd','kk')
    select @id = @id + 1
end
end

Comments