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

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

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are sql objects?

1066


what is uncommittable transactions? : Transact sql

987


Can a table have no primary key?

1038


What is trigger types of trigger?

1050


what are the advantages a stored procedure? : Sql dba

962


How does pl sql work?

949


Is time a data type in sql?

888


If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3988


Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1080


What is execute immediate?

1068


What is rename in sql?

954


How many sql commands are there?

1102


How many postgresql users are there, worldwide?

1045


How do I view tables in sql developer?

925


Why we use stored procedure instead of query?

981