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

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What are the advantages of using stored procedures? Please
don't simply say compilation time will be saved as they are
already complied. Please specify some other advantages.

Question Posted / srikanth

Answers were Sorted based on User's Feedback



What are the advantages of using stored procedures? Please don't simply say compilation time ..

Answer / paras

If your database resides on one server and you are accessing
it from different place then using Stored Procedure reduces
network traffic because you are just passing its name and
few parameters (if any)across the network instead of long query.

Is This Answer Correct ?    6 Yes 0 No

What are the advantages of using stored procedures? Please don't simply say compilation time ..

Answer / santosh kumar sharma

You can encapsulate your business logic in SP. Easy to
maintain as any changes in the business logic, you'll just
have to alter the SP and not your application.

Is This Answer Correct ?    2 Yes 0 No

What are the advantages of using stored procedures? Please don't simply say compilation time ..

Answer / pradip jain

Become secure program from sql Injection.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Why functions are used in sql server?

0 Answers  

How to select top 5 coloumn from a table without using coloumn name

5 Answers  

what exactly sql injuction.how to overcome.....

0 Answers   CTS, IBM,

Explain difference between cross join and full outer join?

0 Answers  

What do you mean by data manipulation language?

0 Answers  

How to configure odbc dsn with different port numbers?

0 Answers  

What should be the fill factor for indexes created on tables? : sql server database administration

0 Answers  

What is the importance of concurrency control?

0 Answers  

What is sql server agent and what are the two modes of authentication in sql server?

0 Answers  

What is a materialized view?

3 Answers  

what are the new features introduced in sql server 2000? : Sql server database administration

0 Answers  

Does any body please help me what question's have asked for SSRS in the interview?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories