Search:     Advanced search
Browse by category:
C/C++   |   Java   |   Oracle/Database   |   SAP   |   ASP .NET   |   Mainframe-DB2   |   Freshers

List few advantages of Stored Procedure.

Add comment
Views: 474
Votes: 1
Comments: 0

A:

Stored procedure can reduced network traffic and latency, boosting application performance.
Stored procedure execution plans can be reused, staying cached in SQL Server's memory, reducing server overhead.
Stored procedures help promote code reuse.
Stored procedures can encapsulate logic. You can change stored procedure code without affecting clients.
Stored procedures provide better security to your data.
.
 

Others in this Category
document What is Aggregate Functions?
document How to find tables without Indexes?
document Q: What are various constraints used in SQL?
document How to copy the tables, schema and views from one SQL Server to another?
document What are the different index configurations a table can have?
document What does it mean to have QUOTED_IDENTIFIER ON? What are the implications of having it OFF?
document What is Identity?
document Q: When do you use WHERE clause and when do you use HAVING clause?
document What is SQL Server Agent?
document What is PIVOT and UNPIVOT?
» More articles



RSS