--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