USE tempdb; GO IF OBJECT_ID('T1', 'U') IS NOT NULL DROP TABLE T1; GO CREATE TABLE T1(id int); GO IF OBJECT_ID ('tr1', 'TR') IS NOT NULL DROP TRIGGER tr1 GO CREATE TRIGGER tr1 ON T1 instead of Insert AS print('Instead of 1'); --INSERT T1 VALUES (1); print('Instead of 2'); -- Odkryt!!! go IF OBJECT_ID ('tr2', 'TR') IS NOT NULL DROP TRIGGER tr2 GO CREATE TRIGGER tr2 ON T1 AFTER Insert AS print('After'); go IF OBJECT_ID ('tr3', 'TR') IS NOT NULL DROP TRIGGER tr3 GO CREATE TRIGGER tr3 ON T1 For Insert AS print('For 1'); INSERT T1 VALUES (2); print('For 2'); go INSERT T1 VALUES (1); SELECT * FROM T1