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

What is self contained multi valued query?

0 Answers  

From where can you change the default port?

3 Answers  

How do I run a trace in sql server?

0 Answers  

Write a SQL query in order to merge two different columns into single column?

0 Answers   QuestPond,

Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s

6 Answers   Broadridge,

What is sql stored procedure?

0 Answers  

what is a self join? Explain it with an example? : Sql server database administration

0 Answers  

What are the Advantages of using CTE in sql server?

0 Answers   Winsol Solutions,

What purpose does the model database server?

0 Answers  

What is the filtered index?

0 Answers  

What is difference between process and thread? Explain lazy writer funcationality.

2 Answers   Microsoft,

Can I run multiple instances of sql server 2000 at the same time on one computer?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories