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 happens when transaction log is full?

923


How to check if stored procedure is running in sql server?

1036


What is sql server transaction log file?

1045


Can we use having clause without group by?

973


explain declarative management framework (dmf) in sql server 2008?

979


what is difference between NULL and ISNULL in SQL Server 2008?

1008


What is resource db in sql server?

1008


How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

1027


What are the types of resultset?

959


Explain the creation and execution of a user-defined function in the sql server?

1040


What is bookmark link in ssrs?

244


What is transactional replication?

953


What stored procedure can you use to display the current processes?

879


What are different types of statements that are supported by sql?

1033


Why would you call update statistics?

1004