UPDATE語法精選

update #ACC
set ACC.ATTR='1'
from #ACC ACC
inner join "ACCTNO" ACT
on ACC.L4_NO=ACT.TYPE_CODE
where ACT.ACCT_YEAR=@this_year and ACT.TYPE_ATRB='2' and ACT.LAYER=4

-----------------

必需跟據ACCTNO中符合的條件去更新#ACC template table, Update #ACC temple

from 欲更新table #ACC, 串接ACCTNO table