Wednesday, February 27, 2013

Our trigger example

Use CommunityAssist
go
Create trigger tr_FlaggedDonations
 on Donation after insert
 As
 Declare @donationAmount money
 Select @donationAmount =DonationAmount
  From Inserted

 if @donationAmount > 10000
 Begin
  if not exists
     (Select name from sys.tables
    Where name='FlaggedDonations')
  Begin
   Create table FlaggedDonations
   (
    DonationKey int, 
    DonationDate datetime, 
    DonationAmount money, 
    PersonKey int, 
    EmployeeKey int
   )
  End
  Insert into FlaggedDonations(
  DonationKey, 
  DonationDate, 
  DonationAmount, 
  PersonKey, 
  EmployeeKey)
  Select DonationKey, 
   DonationDate, 
   DonationAmount, 
   PersonKey, 
   EmployeeKey
  From Inserted
  Print 'Large Donation recieved'
 End

 Select * from FlaggedDonations 

No comments:

Post a Comment