Post

Trigger to Stop Transaction During Christmas Holiday

634
0
2

trigger to stop any

create trigger trgHoliday
on BankAccount
After insrt,update delete
as
begin
if datepart(mm,getdate())='December'
and
if datepart(dd,getdate())=between(15 and 26)
begin
rollback
raiseerror('Sorry....We are on Christmas holiday so.. please visit us again after Christmas')
End
End