批量update表数据

UPDATE A
    SET A1 = B1, A2 = B2, A3 = B3
    FROM A, B WHERE A.ID = B.ID

posted on 2010-02-25 13:19  银翼幻影  阅读(94)  评论(0)    收藏  举报

导航