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

Difference between Triggers and Stored Procedure

Answer Posted / naveen jindal

trigger fired implicitely that is when ever events like
insert/update/delete commands.

Where as stored procedure is not fired implicitely. when
ever we call then only the stored procedure fire.

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of collation sensitivity?

1126


Define tool Manage Statistics in SQL Server 2000 query ?

1094


Do you know the cursor optimization tips?

987


How the authentication mode can be changed?

1132


Difference between report and query parameter. Why do we need different type of parameter?

959


What is a View ? Can we insert, Update and delete a view?

995


How secure is sql server database?

1013


What is the query and subquery?

1078


What is the need for group functions in sql?

1083


Explain throw statement in sql server 2008?

998


What is PROJECTION Operation?

1022


What is an execution plan?

1152


What is 3nf normalization?

996


Is truncate autocommit?

938


What is the recovery model?

992