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.




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

I have to display ten columns values from diffrent ten tables. how many joins are require?

10 Answers   HCL, CarrizalSoft Technologies,


Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?

1 Answers   United Healthcare,


There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.

3 Answers   Amdocs,


What is row by row processing ?

2 Answers  


When we can say that is in BCNF?

3 Answers   BitWise,






What will you do If the low Performance occurs?

2 Answers  


write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

12 Answers   Cognizant, TCS,


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

0 Answers   CTS, IBM,


Difference Between ORDER BY Clause and GROUP BY Clause in SQL?

0 Answers   MCN Solutions,


How to manipulate data from one table to another table ?

0 Answers   MCN Solutions,


What is Query Execution Plan? How does it help optimize or tune a database driven application?

2 Answers   Polaris, Accenture,


What is the difference between a stored procedure and a user defined function in sql server?

2 Answers   Millennium,






Categories