我现在有下面的更新语句 数据比较多 怕出现错误,能否加个事务或是有其它办法呢????/*需要执行的sql语句*/
UPDATE ZFGW
SET ZFGW.webPublish='N' FROM ZFGW,zwgk_ceshi
WHERE ZFGW.hidden_deptcode=zwgk_ceshi.zwgk_dept AND
ZFGW.hidden_index=zwgk_ceshi.zwgk_number
UPDATE ZFGW
SET ZFGW.webPublish='N' FROM ZFGW,zwgk_ceshi
WHERE ZFGW.hidden_deptcode=zwgk_ceshi.zwgk_dept AND
ZFGW.hidden_index=zwgk_ceshi.zwgk_number
UPDATE ZFGW
SET ZFGW.webPublish='N' FROM ZFGW,zwgk_ceshi
WHERE ZFGW.hidden_deptcode=zwgk_ceshi.zwgk_dept AND
ZFGW.hidden_index=zwgk_ceshi.zwgk_number
SET webPublish='N' FROM ZFGW,zwgk_ceshi
WHERE ZFGW.hidden_deptcode=zwgk_ceshi.zwgk_dept AND
ZFGW.hidden_index=zwgk_ceshi.zwgk_number一个语句而已,没必要用什么事务.
set xact_abort on
UPDATE ZFGW
SET ZFGW.webPublish='N' FROM ZFGW,zwgk_ceshi
WHERE ZFGW.hidden_deptcode=zwgk_ceshi.zwgk_dept AND
ZFGW.hidden_index=zwgk_ceshi.zwgk_number
end tran
set xact_abort on
UPDATE ZFGW
SET ZFGW.webPublish='N' FROM ZFGW,zwgk_ceshi
WHERE ZFGW.hidden_deptcode=zwgk_ceshi.zwgk_dept AND
ZFGW.hidden_index=zwgk_ceshi.zwgk_number
commit tran