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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

what is the difference between trigger and storedprocedures

Question Posted / nancy

Answer Posted / nancy

BASIC DIFFERENCE IS trigger is automatically executed without an action required by a user where as stored procedure needs to be explicitly invoked...

a database TRIGGER ia a STORED PROCEDURE that is fired when an insert,update or deletestatements is issued against the associate table.a trigger is fired whwn database related event occurs....

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are the differences between binary and varbinary? : Sql dba

1019

Explain the uses of database trigger.

1098

What is the usage of nvl function?

1025

explain the options of myisamchk to improve the performance of a table. : Sql dba

992

Is it possible to pass parameters to triggers?

1086

What is compilation error in pl sql?

960

What is the main reason behind using an index?

1002

Explian rowid, rownum?

996

is mysql query is case sensitive? : Sql dba

1076

Why commit is not used in triggers?

1024

What are the types of join and explain each?

1021

What are different sql data types?

1017

Explain character-manipulation functions?

1104

How do I find sql profiler?

924

What are the two parts of design view?

1004