Stored Procedure

A stored procedure is a group of sql statements that has been created and stored in the database. Stored procedure will accept input parameters so that a single procedure can be used over the network by several clients using different input data. Stored procedure will reduce network traffic and increase the performance. If we modify stored procedure all the clients will get the updated stored procedure.

Sample of creating Stored Procedure

USE AdventureWorks2008R2;

CREATE PROCEDURE dbo.sp_who

SELECT FirstName, LastName FROM Person.Person;

EXEC sp_who;

EXEC dbo.sp_who;

DROP PROCEDURE dbo.sp_who;

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sesuraj12y ago
A stored procedure is a group of sql statements that has been created and stored in the database. Stored procedure will accept input parameters so that a single procedure can be used over the network by several clients using different input data. Stored procedure will reduce network traffic and increase the performance. If we modify stored procedure all the clients will get the updated stored procedure.

Sample of creating Stored Procedure

USE AdventureWorks2008R2;
GO
CREATE PROCEDURE dbo.sp_who
AS
SELECT FirstName, LastName FROM Person.Person;
GO
EXEC sp_who;
EXEC dbo.sp_who;
GO
DROP PROCEDURE dbo.sp_who;
GO
+1