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

what is datawarehouse? : Sql dba

1018


What makes a good primary key?

1043


What is sql table?

973


what is blob? : Sql dba

1149


What is varray in pl sql?

1076


What are triggers and its uses?

1047


Why do we use procedures in pl sql?

1040


What are different types of triggers?

1113


Is it possible to pass parameters to triggers?

1103


What is query optimization in sql?

985


How do I access sql anywhere database?

970


What are synonyms in sql?

973


What are the types of join and explain each?

1049


What is a file delimiter?

1097


how many ways to get the current time? : Sql dba

1008