Advertisement
Guest User

Untitled

a guest
Dec 7th, 2016
61
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. create trigger spytrigger on Rån_Bank
  2. after insert
  3. as
  4.  
  5. declare @namn varchar(20)
  6. set @namn = (select Bank.Namn from Rån_Bank
  7. join Bank on Bank.BankID = Rån_Bank.BankID
  8. join Rån on Rån_Bank.RånID = Rån.RånID
  9. where Rån.RånID = (select Top 1 Rån.RånID from Rån order by Rån.RånID desc))
  10. print(@namn)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement