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

Trigger and procedures are same but the substantial
difference is when they run.procedure is invoked explicitly
by the user and trigger is executed implicitly. another
diffrence is procedure cannot have the same name as table
name,funtion name or package name but trigger can have same
name as table name or procedure name.

Is This Answer Correct ?    14 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to create a table index in mysql? : Sql dba

1061


What is the use of pl/sql table?

1067


how to write date and time literals? : Sql dba

961


Is subquery faster than join?

1014


What is sql architecture?

1048


How many sql databases can you have on one server?

1083


What are tables and fields?

1033


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

1044


What are sql indexes?

1001


What are dml commands?

1020


how to use myisamchk to check or repair myisam tables? : Sql dba

972


Is natural join same as inner join?

943


What is the use of index in hive?

1007


what are integrity rules?

1026


What is the file extension for sql database?

1000