What are the benefits of using stored procedures over sql
statements?
Answer Posted / vishnu
reduces network traffic
boost up the performance
eliminate webserver overhead
it takes input parameters
if we modify it, clients 'll get newer version automatically
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
Do you know what are acid properties of transaction?
Where is localdb stored?
How to insert new line characters into strings?
Detail about query optimizer?
What sql server means?
Can we call stored procedure in view in sql server?
What is cached report?
What is a view in sql?
What are dml triggers and types of dml triggers?
how can you check the level of fragmentation on a table? : Sql server administration
What is meant by indexing files?
What is role playing dimension with two examples? : sql server analysis services, ssas
In how many ways you can invoke ssrs reports?
How to write a query with a right outer join in ms sql server?