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 / gangi naidu.k

In case of sql queries,it is possible to compile one query
at a time,but incase of stored procedure we can compile
bunch of queries at a time and also it is need at first
time only,suppose we need modification on queries,after
modifications no need to compile again in case of stored
procedures,but in case of sql queries we have to compile
every time.Stored procedure contain queries in compiled
format so execution also fast and tome saving.One more
thing is in case of stored procedures serurity also more.

Is This Answer Correct ?    18 Yes 15 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the limitations/drawbacks or ssrs 2008 r2?

132


How to find the list of fixed hard drive and free space on server?

1110


Where the sql logs gets stored?

944


How to remove duplicate rows from table except one?

952


How to loop through result set objects using mssql_fetch_array()?

1031


Can you pass expressions to function parameters?

1040


Why can there be only one clustered index and not more than one?

936


Does partitioning improve performance?

920


How do indexes help, types?

924


What is tempdb database? : SQL Server Architecture

1122


What is database replication?

1088


Can you use order by when defining a view?

923


How to invoke a trigger on demand?

1039


What do mean by xml datatype?

1021


Tell me the phases a transaction has to undergo?

923