《Database System Concepts Course Introduction》ch04.pptVIP

* * Triggers in MS-SQLServer Syntax create trigger overdraft-trigger on accountfor updateas if inserted.balance 0begin insert into borrower (select customer-name,account-number from depositor, inserted where inserted.account-number =  depositor.account-number) insert into loan values (inserted.account-number, inserted.branch-name, – inserted.balance) update account set balance = 0 from account, inserted where account.account-number = inserted.account-numberend When Not