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 are the Advantages of using CTE in sql server?

1119


List the different types of joins?

1010


What happens if strings are casted into wrong code pages in ms sql server?

1113


Does the order of columns in update statements matter?

913


What is 1nf 2nf?

1009


Can coalesce return null?

1016


What the difference between UNION and UNIONALL?

1040


What is the difference between having clause and where clause in sql server?

1100


What is a non equi join?

981


How to get the definition of a view out of the sql server?

987


How to loop through returning rows?

1036


What happens if date-only values are provided as date and time literals?

1022


Can we use where clause in union?

1069


Do you know how to make remote connection in database?

965


If a table does not have a unique index, can a cursor be opened on it?

915