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
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|
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|
Answer / pradip jain
Become secure program from sql Injection.
|Is This Answer Correct ?||1 Yes||0 No|
I have to display ten columns values from diffrent ten tables. how many joins are require?
Difference b/w Clustered & non-clustered index? Not the bookish definition, but how they internally works in SQL Server?
There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.
What is row by row processing ?
When we can say that is in BCNF?
What will you do If the low Performance occurs?
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
what exactly sql injuction.how to overcome.....
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
How to manipulate data from one table to another table ?
What is Query Execution Plan? How does it help optimize or tune a database driven application?
What is the difference between a stored procedure and a user defined function in sql server?