Cacher is the code snippet organizer for pro developers

-- INSTEAD OF TRIGGER
-- There can only be One INSTEAD OF trigger
-- per table
CREATE TRIGGER ContactTypeDenyInsertTrigger
    ON [Person].[ContactType] 
Instead Of Insert
AS 
    PRINT 'I in`t gonna insert that.' 
GO

-- Execution
INSERT [Person].[ContactType] (Name,ModifiedDate)
VALUES ('Assassin',GETDATE());

-- Output
-- I in`t gonna insert that.
-- (1 row(s) affected)