Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create trigger spytrigger on Rån_Bank
- after insert
- as
- declare @namn varchar(20)
- set @namn = (select Bank.Namn from Rån_Bank
- join Bank on Bank.BankID = Rån_Bank.BankID
- join Rån on Rån_Bank.RånID = Rån.RånID
- where Rån.RånID = (select Top 1 Rån.RånID from Rån order by Rån.RånID desc))
- print(@namn)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement