We walk in the dark places no others will enter
We stand on the bridge and no one may pass

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

create table emptable (salary int);

insert into emptable values (10), (20), (30)

select * from emptable;
go

create trigger tgigupdate
on emptable
for update
as
if update(salary)
begin
print 'can not update salary '
end
go

update emptable set salary = salary + 1;

select * from emptable; --the print statement is issued, all values are updated

drop table emptable;