INSERT INTO temptable SELECT * FROM MarcInfo

WHERE (libid=5595275)

帶結(jié)構(gòu)：

select * into baokanhao.dbo.mvc_downtype from baokanhao.dbo.mvc_downclass

truncate table temptable

復(fù)制表數(shù)據(jù)插入指定列數(shù)據(jù)，根據(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