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

Enlist the characteristics of pl/sql?

1812


Can you upgrade sql express to full sql?

1082


What is online transaction processing (oltp)?

1027


How to select unique records from a table?

1066


how does a local variable is defined using t-sql? : Transact sql

1029


Explain the difference in execution of triggers and stored procedures?

1028


Is the primary key an index?

1031


What does count (*) do in sql?

1020


What has stored procedures in sql?

1073


What's the difference between a primary key and a clustered index?

995


What is a string data type in sql?

1049


Can a procedure in a package be overloaded?

1056


What is a primary key sql?

1051


what are date and time data types? : Sql dba

994


What is difference between pl and sql?

1073