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

what is timestamp in mysql? : Sql dba

1027


Explain character-manipulation functions?

1085


Explain the the update statement in sql?

1002


What are the operators used in select statements?

1016


Explain the difference between rename and alias?

982


What is sqlcommand?

978


Does sql require a server?

966


What is the difference between truncate and drop statements?

1111


How many triggers can be applied to a table?

1013


What is a common use of group by in sql?

1008


Write a query to display the current date in sql?

980


What is nosql vs sql?

1134


How to select unique records from a table?

1018


Which one is better sql or oracle?

924


Are left and right joins the same?

1018