Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What does the INSTEAD OF trigger do?

Answer Posted / vani

Instead of triggers are the procedures that execute in
place of Data Manipulation language (DML)statement on a
table.

for example, if i have INSTEAD-OF-UPDATE Trigger on
TableA,and i execute an update statement on that table,the
code in the INSTEAD-OF-TRIGGER will be executed instead of
the update statement that I executed.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the order by used for?

965


Explain different types of collation sensitivity?

923


How many types of functions are there in sql server?

871


How sql server enhances scalability of the database system?

1108


What is subquery in sql?

986


What are the steps you should follow to start sql server in single-user mode?

845


What is the difference between Triggers and Stored Procedure?

1030


What is deploy, process and build? : sql server analysis services, ssas

1033


Why use “pivot” in sql server?

1041


Scalability, Availability, Integration with internet, etc.)?

2818


What are the different Authentication modes in SQL Server and how can you change authentication mode?

1020


How would you go about developing a ssrs report?

155


Explain the third normal form(3nf)?

892


Is there any difference between primary key and unique with the not null condition?

885


Explain about service Broker functions?

978