sql server用sql语句批量插入数据复制表数据插入指定列数据

sql server用sql语句批量插入数据，以下为插入20000行数据，大约所花时间为5秒

declare @totalqi int,@issuedate datetime

set @totalqi=36

while @totalqi<20000

begin

set @issuedate=dateadd(day,@totalqi,getdate())

insert into e_eachqi (totalqi,issuedate,downpdf) values(@totalqi,@issuedate,'这里是多余的数据,没有添加到索引的数据---关于日期时间字段索引的开销')

set @totalqi=@totalqi+1

end

插入数据库，用于系统测试或者测试查询时间，查看测试索引是否生效。

根据已有数据插入差不多的数据：

insert into OutVehicle202411(ParkingId, TokenNo, TokenType, ParkId, TcmId, TcmName, StaffNo, StaffName, RegPlate, InAutoPlate, 
     InLaneName, InTime, InPicture, InPicture2, InPictureStaff, InOperatorId, InOperatorName, InType, InFlag, InLaneId, 
     LotFullRemark, GroupLotState, ReservationNo, InTerminalId, InTerminalName, InRemark, OutAutoPlate, OutLaneName, 
     OutTime, OutPicture, OutPicture2, OutPictureStaff, OutOperatorId, OutOperatorName, OutType, OutFlag, OutLaneId, 
     OutRemark, StayLasts, TerminalId, TerminalName, TranAmount, AccountPayAmount, CashAmount, FreeAmount, 
     DeductedAmount, DeductedHours, DeductedHoursAmount, VehicleColor, VehicleBand, VehicleCategory, PlateColor, 
     Province, Gid,Rid)
 select top (1) newid(), TokenNo, TokenType, ParkId, TcmId, TcmName, StaffNo, StaffName, RegPlate, InAutoPlate, 
     InLaneName, '2024-11-03 08:14:40.000' AS Expr1, InPicture, InPicture2, InPictureStaff, InOperatorId, InOperatorName, 
     InType, InFlag, InLaneId, LotFullRemark, GroupLotState, ReservationNo, InTerminalId, InTerminalName, '', 
     OutAutoPlate, OutLaneName, '2024-11-03 09:14:40.000' AS Expr2, OutPicture, OutPicture2, OutPictureStaff, OutOperatorId, 
     OutOperatorName, OutType, OutFlag, OutLaneId, '', StayLasts, TerminalId, TerminalName, TranAmount, 
     AccountPayAmount, CashAmount, FreeAmount, DeductedAmount, DeductedHours, DeductedHoursAmount, VehicleColor, 
     VehicleBand, VehicleCategory, PlateColor, Province, Gid, newid() from OutVehicle WHERE (TokenNo = '苏DA21J3') ORDER BY Id DESC


--查找 
select top (1) * from OutVehicle WHERE (TokenNo = '苏DA21J3') ORDER BY Id DESC