Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
what is instead of trigger? Give a example
October 19, 2010
What is instead of trigger? In which condition we should use it?
Posted Date: October 20, 2010 Points: 5
Do you want the replacement of trigger or you want to know INSTEAD-OF in sql triggers
For INSTEAD-OF in sql server trigger
A trigger is a database object similar to a stored procedure that executes in response to certain actions that occur in your database environment. SQL Server 2005 is packaged with three flavors of trigger objects: AFTER, data definition language (DDL), and INSTEAD-OF.
To know more about it refer to
Hope this helps.
Thanks & Regards,
Posted Date: October 27, 2010 Points: 5
Instead of Triggers is executing one procedure instead of the other based on the conditions
To post reply
Related Questions Related Questions
How many types of trigger are there in sql server
Hello Praveen thanks for reply, but can u give me an example on it
Trigger in sql server 2005
give me a program of random no. generatio... and whats the problem in below code.?
how to give fade transition effect to asp.menu control in asp.net
How to Give Password to Vb.Net Setup File
please give me some sample coding for Telerik controls
Can we have primary key for more than two column? In which situation we will use it Give an example
What is default constraint? Give an example
How do we implement in forum concept in Asp.net , Please give sample code?
Latest Forum Questions From The Same Category
Help to get SQL output
how to restore my sql database from my hosting provider?
SQL query to update date range
Add allowance to employee table is wrong or true according to my case
how to remove trailing zeroes in a decimal in sql server
Required Union All Result in two different column
Sql Multiple table data retrival
Table Translation records
How select huge Data from sql without take long time?
Passing using parameter in store procedure get the top3 record from the table
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend