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 difference between trigger and storedprocedures

Answer Posted / satish kumar

stored procedure are collections of T-sql statements and
they are pre complied staements,it not requiers any
complitation.

trigger are not pre complied statements , and they are
going to activate only when certain action takes place like
insert , update, delete,

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a column in a table?

1126


What is pl sql quora?

1167


What is the use of count (*) in sql?

1053


What is the purpose of primary key?

1029


what is the difference between delete and truncate commands? : Sql dba

1070


What pl/sql package consists of?

1081


How do I run a sql trace?

960


Is like operator in sql case sensitive?

1027


What does the file extension accdb stand for?

972


Does sql profiler affect performance?

994


how to drop an existing index in mysql? : Sql dba

1069


What is the difference between the conventional and direct path loads? : aql loader

1400


What is sqlerrm?

939


What is an example of translating a date into julian format?

1124


How do you break a loop in pl sql?

1049