2011年12月30日
UPDATE SET FROM WHERE 续
摘要： UPDATE BSET B.InDate=a.InDate,B.EditDate=A.EditDate,B.OperateDate=A.OperateDateFROM (SELECT T.InDate,T.EditDate,T.OperateDate,T.SONumber FROM SOTracking AS T WITH(NOLOCK) WHERE T.operation=130 and T.SONumber in(111,222,333)) AS A INNER JOIN SOTracking AS B ON B.SONumber=a.SONumbe... 阅读全文
posted @ 2011-12-30 16:40 _cc 阅读(5901) 评论(3) 推荐(0)