SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE [dbo].[Person] ([ID] [int] NOT NULL,
                             [Name] [varchar](50) NULL,
                             [Age] [int] NULL,
                             CONSTRAINT [PK_Person]
                                 PRIMARY KEY CLUSTERED ([ID] ASC));
CREATE TABLE [dbo].[PersonLog] ([PersonID] [int] NOT NULL,
                                [Name] [varchar](50) NULL,
                                [Age] [int] NULL,
                                [AddDate] [datetime] NULL,
                                [UpdateDate] [datetime] NULL,
                                [DeleteDate] [datetime] NULL);
CREATE TRIGGER [dbo].[Trigger_Insert] ON [dbo].[Person]
AFTER INSERT AS
BEGIN

    SET NOCOUNT ON;
    --If a single row with a value of 130 or more exists throw as error, otherwise insert as normal.
    IF EXISTS(SELECT 1 FROM Inserted WHERE Age >= 130)
        THROW 56789, N'Insert on table ''dbo.Person'' failed in the trigger ''dbo.Trigger_Insert''. The age of a person cannot be greater than or equal to 130.', 16;
    ELSE
        INSERT INTO PersonLog (PersonID,
                               Name,
                               Age,
                               AddDate)
        SELECT ID,
               Name,
               Age,
               GETDATE()
        FROM inserted;
END;
--Works
INSERT INTO dbo.Person (ID,
                        Name,
                        Age)
VALUES (1, 'John', 37);
1 rows affected

--Fails
INSERT INTO dbo.Person (ID,
                        Name,
                        Age)
VALUES (2, 'Jane', 137);
Msg 56789 Level 16 State 16 Line 8
Insert on table 'dbo.Person' failed in the trigger 'dbo.Trigger_Insert'. The age of a person cannot be greater than or equal to 130.

--Fails
INSERT INTO dbo.Person (ID,
                        Name,
                        Age)
VALUES (3, 'Greg', 131),
       (4, 'Hannah', 29);
Msg 56789 Level 16 State 16 Line 8
Insert on table 'dbo.Person' failed in the trigger 'dbo.Trigger_Insert'. The age of a person cannot be greater than or equal to 130.

--Fails
INSERT INTO dbo.Person (ID,
                        Name,
                        Age)
VALUES (5, 'Sam', 18),
       (6, 'Samantha', 142);
Msg 56789 Level 16 State 16 Line 8
Insert on table 'dbo.Person' failed in the trigger 'dbo.Trigger_Insert'. The age of a person cannot be greater than or equal to 130.

SELECT *
FROM dbo.Person;


ID
Name
Age


1
John
37


DROP TABLE dbo.Person;
DROP TABLE dbo.PersonLog;