CREATE TRIGGER trigger1
ON emp
FOR INSERT
AS
ROLLBACK
GO

INSERT INTO emp VALUES(10001, 'TEST2', 'SALESMAN', null, null, 500, null, 10)
GO

CREATE TRIGGER trigger2
ON emp
FOR INSERT
AS
IF EXISTS (SELECT empno FROM inserted WHERE sal < 1000)
    ROLLBACK
GO

DISABLE TRIGGER trigger2 ON emp
GO

SELECT * FROM emp
GO

INSERT INTO emp VALUES
(10001, 'TEST2', 'SALESMAN', null, null, 500, null, 10),
(10002, 'TEST3', 'SALESMAN', null, null, 1500, null, 10),
(10003, 'TEST4', 'SALESMAN', null, null, 500, null, 10)
GO

CREATE TRIGGER trigger3
ON emp
FOR INSERT
AS
DECLARE @empno INT
DECLARE kursor CURSOR FOR SELECT empno FROM inserted WHERE sal < 1000
OPEN kursor
FETCH NEXT FROM kursor INTO @empno
WHILE @@FETCH_STATUS = 0
BEGIN
    DELETE FROM emp WHERE empno = @empno
    FETCH NEXT FROM kursor INTO @empno
END
CLOSE kursor
DEALLOCATE kursor