Trigger to Stop Transaction on Sunday

In this code snippet I am writing trigger to stop transaction on Sunday

 

  1. Create trigger trgBank  
  2. On BankAccount  
  3. After Insert, Update, Delete  
  4. As  
  5. Begin  
  6. If datapart(wd, getdate()) = ’Sunday’  
  7. Begin  
  8. Rollback  
  9. Raiseerror(‘Today we are not open‘);  
  10. End  
  11. End