--1
ALTER TRIGGER t1
ON dept
FOR INSERT
AS
ROLLBACK
GO
DISABLE TRIGGER t1 ON dept
GO
--INSERT INTO dept VALUES(40,'Deptname','Warsaw')
--2
ALTER TRIGGER t2
ON emp
FOR DELETE
AS
IF EXISTS(SELECT empno from deleted where mgr=0)
ROLLBACK
GO
--DELETE FROM EMP where ENAME='CLARK'
DISABLE TRIGGER t2 ON emp
GO
--3
ALTER TRIGGER t3
ON emp
FOR INSERT
AS
IF (SELECT sal from inserted)>=(SELECT max(sal)from emp)
ROLLBACK
GO
--INSERT INTO emp VALUES(10001, 'TEST2', 'SALESMAN', null, null, 50000, null, 10)
disable TRIGGER t3 on emp
GO
--4
ALTER TRIGGER t4
ON emp
FOR INSERT,UPDATE
AS
IF EXISTS(SELECT EMPNO from inserted where sal<1000)
ROLLBACK
IF EXISTS(SELECT EMPNO from updated where sal<1000)
ROLLBACK
GO
disable TRIGGER t4 on emp
GO
--5
ALTER TRIGGER t5
ON emp
FOR INSERT,UPDATE
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
GO
--INSERT INTO emp VALUES(10001, 'TEST2', 'SALESMAN', null, null, 500, null, 10)
DISABLE TRIGGER t5 ON tmp