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. 4 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 default TCP/IP port number does SQL Server run on? SQL Server runs on 1433 port number. Happy Reading Can you list some Maximum capacity specifications of SQL Server? Below are the Maximum capacity specifications according to SQL I have a table with 100 records. Now I want to generate INSERT statements with the same data. How will you generate? Open SSMS — Right click on Database — Tasks Latest Comments September 24, 2019 sudhasu one Reply September 25, 2019 U uma Excellent,good Reply September 26, 2019 Lakshma It’s good Reply September 26, 2019 Noel Roy Flores cool Reply 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. This site uses Akismet to reduce spam. Learn how your comment data is processed.