close
[SQL] 從B表某欄位倒資料到A表某欄位
update TableA
set TableA.ColumnY= TableB.ColumnY
from TableA , TableB
where TableA.ColumnX= TableB.ColumnX
update d
set d.MONEY_CARD = m.MONEY_CARD
from TB_TRA_TRADEDETAIL d , TB_CMS_PRODUCT_MENU m
where d.MONEY_CARD is null and d.GODS_ID = m.MENU_GUID
update ad
set ad.DESINGER_ID = t.DESINGER_ID
from TB_TRA_ASSISTANTDEATIL ad , TB_TRA_TRADE t
where ad.DESINGER_ID <> t.DESIGNER_ID
全站熱搜
留言列表
