22,300
社区成员




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'