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 / satish kumar

stored procedure are collections of T-sql statements and
they are pre complied staements,it not requiers any
complitation.

trigger are not pre complied statements , and they are
going to activate only when certain action takes place like
insert , update, delete,

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many aggregate functions are available there in sql?

970


How to change the order of columns in Oracle SQL Plus ?

1042


What is trigger in flip flop?

1002


How to run sql statements with oracle sql developer?

1048


What is use of package in pl sql?

998


What is meant by cursor in sql?

975


Can we enter data in a table in design view?

954


Who developed sql?

1021


What are the sql versions?

929


What are the different ddl commands in sql?

1137


What does cursor do in sql?

1005


How do I remove all records from a table?

1063


What is the sql query to display the current date?

1032


How do I view an execution plan in sql?

970


What is the difference between having clause and where clause?

1048