SQL Trigger Inserted,Deleted Example

Information Table: 1JackEnderson5000Engineer2MariaAllen7000Architect3OliverPat4000Engineer4RickQuenn5000Developer5BobQuit7000Marketer6AllenThin10000Architect7SaraSait7000Engineer8OsmanKaya5000Marketer19megandavis6000Architect9Ali            kaya           6000Developer10jackquenn6000Engineer11ameliataylor7000Marketer12sophiewilson9000Architect13avaJones9000Engineer14thomaslee4000Architect15lilydavies2000Developer16jessicamartin5000Engineer17miamorton4000Developer18isebellaroberts8000Architect20jenniferwhite7000Engineer22IsabellaSmith5000Engineer21jackallen6000Engineer23AmeliaJones7000Architect24OliviaWilliams9000Developer25IslaBrown20000Developer26PoppyTaylor12000Architect27EmilyDavies7000Marketer28JessicaWilson5000Engineer29LilyEvans3000Marketer30SophieThomas2000Architect CREATE TABLE insert_person ( [ID] tinyint, [NAME] nvarchar(max), [SURNAME] nvarchar(max), [SALARY] int, [JOB] nvarchar(max) ) CREATE TABLE delete_person ( [ID] tinyint, [NAME] nvarchar(max), [SURNAME] nvarchar(max), [SALARY] int, [JOB] nvarchar(max) ) ALTER TRIGGER [insert] ON information AFTER INSERT AS BEGIN INSERT INTO insert_person SELECT Person_id,Person_FirstName,Person_LastName,Person_Salary,Person_Job FROM inserted END ALTER TRIGGER [deleted]...