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 What is the basic difference between different types of Ranking functions? Ranking functions ROW_NUMBER: It just returns the sequence numbers What are the steps to be followed to use Cursor? Steps: Declare cursor Open cursor Fetch records Close cursor How do you generate the sequence of dates from one date to other? This is possible through Recursive CTEs. You can execute 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.