------
------ Ukazka INSTEAD OF DELETE
------

USE tempdb;
GO
IF OBJECT_ID('dbo.T1')IS NOT NULL   DROP TABLE dbo.T1;
GO

CREATE TABLE T1 (Col1  varchar(32))
GO

IF OBJECT_ID ('tr_T1', 'TR') IS NOT NULL DROP TRIGGER tr_T1
GO
---- 1 uncomment
--CREATE TRIGGER tr_T1 ON T1 
--INSTEAD OF DELETE -- !!!!!!!!
--AS
--    PRINT 'Lutujem - nie je dovolene vymazat udaje'
--	---- 2 uncomment => dodatocne vymaze trigger
--	--DELETE T1
--GO

INSERT JAJ
    SELECT 'Trigger' union
    SELECT 'nedovoli' union
    SELECT 'riadky' union
    SELECT 'vymazat'
GO
 
SELECT * FROM T1
DELETE FROM T1 -- <=> DELETE T1 
SELECT * FROM T1
GO
 


-------------------------------------------------------------
-- Koniec.
-------------------------------------------------------------