In this code snippet I am writing trigger to stop transaction after update of salary.
- Create trigger trgEmp
- On Employee
- After Update
- As
- Begin
- declare @p1 small money,
- declare @p2 small money
- select @p1 = sql from deleted
- select @p2 = sql from inserted
- If(@p1 > @p2)
- Begin
- Rollback
- Raiseerroe(‘Transaction can 't be completed please check incremented salary ‘);
- End End