Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --Trigger Loan Confirmation
- CREATE TRIGGER trgThankyou
- ON Loan
- AFTER INSERT
- AS
- BEGIN
- DECLARE @newLoanID INT = (SELECT TOP 1 loanID FROM Loan ORDER BY loanID DESC) --Getting the newest loan created
- DECLARE @itemTitle NVARCHAR(MAX) = (SELECT title FROM Item --Getting the title of the book or dvd
- JOIN Loan ON Item.itemID = Loan.itemID
- WHERE Loan.loanID = @newLoanID)
- DECLARE @dueDate DATE = (SELECT dueDate FROM Loan WHERE loanID = @newLoanID); --Getting the due date
- --Prints to display info to the user
- PRINT 'Order Number: '+CAST (@newLoanID AS VARCHAR(MAX));
- PRINT 'You have loaned: '+@itemTitle;
- PRINT 'It is due: '+CAST (@dueDate AS VARCHAR(MAX));
- END
- GO
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement