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 is the main difference between after trigger and
instead trigger.

Answer Posted / durga prasad

After Trigger fires an operation after any
insert,update,delete operations performed on a table.

Instead Of Trigger fires an operation instead of performing
user specified operation.

u can create instead of trigger on views but u can not
create after triggers on views

Is This Answer Correct ?    38 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to remove duplicate rows from table?

1159


What is amo? : sql server analysis services, ssas

1043


Explain what you mean by 3 tier architecture.

1015


How to get the query of a table in sql server?

848


What is a performance monitor?

916


Tell me about the approaches which you used to counter the DI problems.

1266


What do you mean by stored techniques? How would we use it?

975


Explain what is row_number function?

971


What are the differences between DDL, DML and DCL in SQL?

1169


What does it mean to invest in the index?

905


Explain transaction server implicit?

923


Do you know how to implement service broker?

885


When do you think a developer should use sql server-based cursors?

975


How to assign new column names in a view?

862


What is a field name?

913