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

when is the use of update_statistics command? : Sql dba

973


Where do we use pl sql?

946


How to combine two stored procedures in sql?

1124


What is rownum in sql?

967


How many tables can a sql database have?

927


How to use boolean type in select statement?

997


How do I count records in sql?

947


Which table is left in join?

916


How do you go back in sql?

942


what is user defined functions? : Sql dba

977


Explain isolation levels. : Transact sql

1017


what is 'mysqlshow'? : Sql dba

975


What is pl/sql language case sensitive?

1061


which tcp/ip port does sql server run on? : Sql dba

966


What is application trigger?

947