Question

sqlserver触发器怎么锁定一列设置成插入和修改都触发

下面是我写的触发器，需要锁定A207201这一列，当A207201，插入或者修改时，触发下面逻辑，求大神指点一下。

create trigger tri_A207201
on A207
for insert,update
as
if update(A207201)
Begin
update A207
set A207202=(select w.CELL_VALUE
from WAGE_STANDARD_VALUE w,inserted i
where VCODE_VALUE=i.A207201
)
where A207201=(select A207201
from inserted
)
end

Answer 1

可以创建如下类似触发器
create trigger depart_update on depart for update
as
begin
if update(deptno)
begin
update worker set deptno = b.deptno from inserted b where worker.col1 = b.col1

end

end