sql server用sql語句批量插入數(shù)據(jù)，以下為插入20000行數(shù)據(jù)，大約所花時(shí)間為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,'這里是多余的數(shù)據(jù),沒有添加到索引的數(shù)據(jù)---關(guān)于日期時(shí)間字段索引的開銷')

set @totalqi=@totalqi+1

end

插入數(shù)據(jù)庫，用于系統(tǒng)測(cè)試或者測(cè)試查詢時(shí)間，查看測(cè)試索引是否生效。

根據(jù)已有數(shù)據(jù)插入差不多的數(shù)據(jù)：

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