22,206
社区成员
发帖
与我相关
我的任务
分享
insert into C31VisaInfo(ID,IssuanceDate,ExpirationDate,Status,VesselID)
select top 1 '18','2014-1-1','2014-1-1','有效', ID, from C31VesselInfo where VesselName = '瑞安0018'
insert into C31VisaInfo(ID,IssuanceDate,ExpirationDate,Status,VesselID)
values ('18','2014-1-1','2014-1-1','有效',(select top 1 ID from C31VesselInfo where VesselName = '瑞安0018'))
insert into C31VisaInfo(ID,IssuanceDate,ExpirationDate,Status,VesselID)
select top 1 '18','2014-1-1','2014-1-1','有效',ID from C31VesselInfo where VesselName = '瑞安0018'