摘要:
merge into dbo.ak_SloteCardTimes a using(select RecordID,CardNO,SloteCardTime from dbo.Tb_CardDate b ) c on(a.RecordID=c.RecordID)when matched then update set a.CardNO=c.CardNO ,a.SloteCardTime=c.SloteCardTimewhen not matched then insert(RecordID,CardNO,SloteCardTime)values(c.RecordID,c.CardNO,c.Sl. 阅读全文