SQL-Server-Procedure .

In this session i have discussed the SQL Server Procedure .

A stored procedure is prepared sql server code that you can save inside the sql server and reuse again and again . Suppose you have a sql server query of some lines of code write over and over again just save the query as sql server stored procedure and call it to execute the sql code .


Advantages : There are following advantages of using stored procedure .

1-Reusebility

2-Speed

3-Security

4-Imporve Performance

1-Reuasebility -Store Procedures allow developers to write SQL statements once and use them repeatedly and share the data multiple times .

2-Speed - Stored Procedure compile only once during creation . So You do not need to compile every time due to this it will increase the speed of execution .

3-Security - Stored Procedure is very important in security purpose . In Stored Procedure there are no direct accesses to the tables, it prevents unauthorized manipulation of records inside the tables .

4-Improve Performance - A Stored procedure can reduce the stress and load to the bandwidth and server. The procedure accepts limited and meaningful amount of data through its predefined parameters,


Disadvantages : There are following disadvantages of Stored Procedure .

1-Debugging

2-Expensive

1-Debugging - Debugging is not very easy work in stored procedure .

2-Expensive - Stored Procedure is very expensive .

Welcome to AndroidATPoint.

back image                     next image