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
List the different types of joins?
Tell me what are the advantages of using stored procedures?
How to list all login names on the ms sql server?
What happens if time-only values are provided as date and time literals?
What are the different authentication modes in sql server?
What are translations and its use? : sql server analysis services, ssas
What do you understand by recursive stored procedures?
Difference between primary key and clustered index?
How to count groups returned with the group by clause in ms sql server?
How are the unique and primary key constraints different?
What is single-user mode?
What is partition in sql server?
What is the purpose of indexing?
do you know how to configure db2 side of the application? : Sql server database administration
What is report server project?