Post
Ask Question

Create Trigger in SQL Server

Create trigger TriggerName
on TableName
Trigger type -- After or Instead
Operation --Insert/update /delete or insert,update,delete
as
begin
condition
RaiseError('Message ')
End
 
Example

Create a trigger to not to allow Decrement  Employee Salary, 
  1. Create trigger trgEmp  
  2. on Employee  
  3. After Update  
  4. As  
  5. Begin  
  6. declare @p1 small money  
  7. declare @p2 small money  
  8. select @p1=sql from deleted  
  9. select @p2=sql from inserted  
  10. if(@p1>@p2)  
  11. Begin  
  12. Rollback  
  13.  RaiseError('Operation Can't perform')  
  14. End  
  15. End