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's the purpose of Stored Procedure?

Answer Posted / dharmendra k. dixit

Stored Procedures has some advantages thats y we are using
SP..
some advantages are..
(1)Stored Proc is a Pre Compiled statement..so its reduces
Network Traffic.
(2). We can execute SP inside SP.
(3). Through it we can protect from SQL Injection.

Is This Answer Correct ?    17 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

in the physical file layout, where should the transaction log be stored in relation to the data file? : Sql server administration

1121


How to remove duplicate rows from table?

1314


In how many ways you can invoke ssrs reports?

147


Name some of the open source software that you can use in alternative to SSR?

170


What is difference between inner join and join?

1096


Are all views updatable ?

1204


What happens if ntwdblib.dll is missing on your machine?

1190


What are the steps you should follow to start sql server in single-user mode?

955


Is oracle faster than sql server?

1009


Explain in brief about Microsoft SQL server?

1173


What are the advantages of policy management?

1046


What are .mdf files?

1016


When columns are added to existing tables, what do they initially contain?

1099


What is the purpose of the master database?

1201


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

1043