SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table tb(InvoiceNo int, InvoiceDate Date, CustomerName varchar(10));
Create Trigger TriggerDate
    On tb
    AFTER INSERT,UPDATE 
    As
    Begin
        Declare @IVDate Date;
        DECLARE my_Cursor CURSOR FOR SELECT InvoiceDate FROM INSERTED; 
        OPEN my_Cursor; 
        
     
        FETCH NEXT FROM my_Cursor INTO @IVDate;
        
        WHILE @@FETCH_STATUS = 0 
        BEGIN
        
        FETCH NEXT FROM my_Cursor INTO @IVDate;
        If @IVDate < '2022-01-01'
           RollBack Transaction
        
        END
        CLOSE my_Cursor; 
        DEALLOCATE my_Cursor;
    END
    
    

insert into tb values(1,'2022-05-02','A');
insert into tb values(2,'2021-08-06','B');
Msg 3609 Level 16 State 1 Line 2
The transaction ended in the trigger. The batch has been aborted.

select * from tb


InvoiceNo
InvoiceDate
CustomerName


1
2022-05-02
A


Delete from TB
1 rows affected

insert into tb values(2,'2021-08-06','B');
insert into tb values(1,'2022-05-02','A');---This record is correct but still it won't insert
Msg 3609 Level 16 State 1 Line 1
The transaction ended in the trigger. The batch has been aborted.

select * from tb


InvoiceNo
InvoiceDate
CustomerName