SQL: 用存储过程store procedure的方法往数据表中插入多条相同的数据

  create procedure insertRecord
  as
  declare @ID int
  set @ID=1
  while(@ID<82)
  begin
   INSERT INTO tableA
  (columnA,columnB,columnC,columnD, columnE,columnF)
  values(421926,3,'29','2018-09-11',1,38140)
  set @ID=@ID+1
  end
  go
  
  exec insertRecord
  
  drop procedure insertRecord