摘要: 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. 阅读全文
posted @ 2014-04-01 14:48 蜜雪粮液 阅读(905) 评论(0) 推荐(0) 编辑