What are the benefits of using stored procedures over sql
statements?
Answer Posted / yudistara
reducing network traffic..
user friendlyness..
no need to write queries every time..
sp help to improve perfrmance
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Is it possible for a stored procedure to call itself or recursive stored procedure?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
How can you ensure that the database and sql server based application perform well?
What are the differences between stored procedure and view in sql server?
What are the types of joins in sql?
What are the different types of data sources in ssrs?
What are examples of triggers?
What happens if null values are involved in arithmetic operations?
What is fill factor and pad index?
Explain filtered indexes benefits?
What is extent? Types of extents?
What is the command to change the recovery model?
What is the difference between grant and with grant while giving permissions to the user?
What is exclusive locks?
What is the difference between a local and a global temporary table?