create table t(BB int) insert into t select 1 gocreate trigger cfq on t for update asif @@rowcount=0 returnif update(BB) begin raiserror('禁止修改该列!',16,1) rollback tran end goupdate t set BB=2 where BB=1 go select * from tdrop trigger cfq drop table t
create trigger tri_AA on AA for INSTEAD OF update as begin IF UPDATE(BB) return end
insert into t select 1
gocreate trigger cfq on t
for update
asif @@rowcount=0 returnif update(BB)
begin
raiserror('禁止修改该列!',16,1)
rollback tran
end
goupdate t set BB=2 where BB=1
go
select * from tdrop trigger cfq
drop table t
create trigger tri_AA
on AA
for INSTEAD OF update
as
begin
IF UPDATE(BB)
return
end