Simple triggers in SQL Server

/******************* Record the journal deletion information ************** * ************/create trigger delete_journalon [DBO]. [Journal] After Delete as begin declare @ journal_num varchar (50), @ journal_title varchar (50); select @ journal_num = journal_num, @ journal_title = journal_title from deleted; insert into journal_log values (@ journal_num, @ journal_title, CURRENT_USER, current_timestamp); Update journal_count set jour_count = jour_count-1; end; /*************************************** **************************/

The trigger achieves the following effect: After deleting a record in Journal, insert the deleted record to journal _ log, and subtract the value of jour_count from the journal_cout table by 1.

The journal_log table is as follows:

Create Table journal_log
(
Num varchar (50 ),
Title varchar (50 ),
Username varchar (20 ),
Timestamp date
)