ok now my code which is not allowing salary coulmn in my emptable

to get updated

create trigger tgigupdate

on emptable

for update

as

if update(salary)

begin

print 'can not update salary '

end

go

it is working fine as I do not want to allow any updates of salary col.

here it does not allow any single row update and also multiple row update s to salary column.what according to you should happen is this correct?

pls suggest and explain if it is wrong.