Information Table:
| 1 | Jack | Enderson | 5000 | Engineer |
| 2 | Maria | Allen | 7000 | Architect |
| 3 | Oliver | Pat | 4000 | Engineer |
| 4 | Rick | Quenn | 5000 | Developer |
| 5 | Bob | Quit | 7000 | Marketer |
| 6 | Allen | Thin | 10000 | Architect |
| 7 | Sara | Sait | 7000 | Engineer |
| 8 | Osman | Kaya | 5000 | Marketer |
| 19 | megan | davis | 6000 | Architect |
| 9 | Ali | kaya | 6000 | Developer |
| 10 | jack | quenn | 6000 | Engineer |
| 11 | amelia | taylor | 7000 | Marketer |
| 12 | sophie | wilson | 9000 | Architect |
| 13 | ava | Jones | 9000 | Engineer |
| 14 | thomas | lee | 4000 | Architect |
| 15 | lily | davies | 2000 | Developer |
| 16 | jessica | martin | 5000 | Engineer |
| 17 | mia | morton | 4000 | Developer |
| 18 | isebella | roberts | 8000 | Architect |
| 20 | jennifer | white | 7000 | Engineer |
| 22 | Isabella | Smith | 5000 | Engineer |
| 21 | jack | allen | 6000 | Engineer |
| 23 | Amelia | Jones | 7000 | Architect |
| 24 | Olivia | Williams | 9000 | Developer |
| 25 | Isla | Brown | 20000 | Developer |
| 26 | Poppy | Taylor | 12000 | Architect |
| 27 | Emily | Davies | 7000 | Marketer |
| 28 | Jessica | Wilson | 5000 | Engineer |
| 29 | Lily | Evans | 3000 | Marketer |
| 30 | Sophie | Thomas | 2000 | Architect |
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] ON information
AFTER INSERT
AS
BEGIN
INSERT INTO delete_person
SELECT Person_id,Person_FirstName,Person_LastName,Person_Salary,Person_Job FROM deleted
END
INSERT INTO information
VALUES (45,'Jack','Allen',1000,'Marketer')
DELETE information
WHERE Person_id = 45
Leave a comment