create trigger trg on employee
for update
as
if Update(empname)
print 'Emp Name Updated'
update employee set empname='pkm' where id=1
o/p
Emp Name Updated
(1 row(s) affected)
for update
as
if Update(empname)
print 'Emp Name Updated'
update employee set empname='pkm' where id=1
o/p
Emp Name Updated
(1 row(s) affected)