How many Instead Of Triggers we can create on a table? Posted in SQL Interview Questions, TSQL Interview Questions by Chandrasekhar Raparthi On September 8, 2016. No comments Only one Instead of Trigger per operation(Delete/Insert/Update) is possible to create on a table. Happy Reading Share this:GooglePinterestEmailTwitterLinkedInFacebook Tags:Triggers Related Posts How to display only Even numbered rows from a table? ————————————————————————– USE [ADVENTUREWORKS2012] GO ————————————————————————– — Fetching only Even Why do we set ANSI_NULLS ON before writing a script? ANSI_NULLS property is used for comparing ANSI NULLS. By Is it possible to create a Foreign key without Primary key? Yes. We can create a Foreign key without having Leave a Reply Cancel reply Your email address will not be published. Required fields are marked *Comment Name * Email * Website Notify me of follow-up comments by email. Notify me of new posts by email.