Use Trigger to manage a Recycle Bin for deleted items

CREATE TRIGGER BooksDeleteTrigger
    ON MyBooksDB.Books
    AFTER DELETE
AS
  INSERT INTO BooksRecycleBin
    SELECT *
    FROM deleted;
GO

Found a mistake? Have a question or improvement idea? Let me know.

Table Of Contents