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 / srikanth

Trigger will fire when the condition arises but the stored
procedure will execute when the user or main programme
wants its need.

triggers can't accept parameters from users whereas stored
procedures can accept parameters from users.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to run sql*plus commands in sql developer?

1156


Which are sql * plus commands?

1124


What are character functions in sql?

938


what is rdbms? : Sql dba

1012


What is forward declaration in pl sql?

1077


What is relationship? How many types of relationship are there?

1180


Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1269


What is cold data?

958


When is the update_statistics command used?

1116


what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1004


What is t-sql? : Transact sql

984


What is sap sql anywhere?

1076


Which sorts rows in sql?

1017


How many developers work on postgresql?

979


What is pivot table in sql?

1106