从另外一个表复制数据，复制表数据带结构复制表数据插入指定列数据

INSERT INTO temptable SELECT * FROM MarcInfo

WHERE (libid=5595275)

带结构：

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

truncate table temptable

复制表数据插入指定列数据，根据已有数据插入差不多的数据：

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