sql server用sql語句批量插入數(shù)據(jù)，以下為插入20000行數(shù)據(jù)，大約所花時間為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)于日期時間字段索引的開銷')

set @totalqi=@totalqi+1

end

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

根據(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