create trigger trgafterupdate on dbo.Employee_Test
for update
as declare @emp_id int;
declare @emp_name nvarchar(50);
declare @emp_sal decimal(10,2);
declare @status nvarchar(50);
select @status=i.status from inserted i;
if(@status='SUCCESS')
begin
print 'abc';//on true condition code here
end
else
print 'andd';// on false condition code here
In trigger body ,table named inserted has been used .this table is a logical table and contains the row that has been updated
[edit]Code block fixed[/edit]