Store 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.
Ex:-
sql server
CREATE PROCEDURE dbo.uspGetAddress @City nvarchar(30)
AS SELECT * FROM Person.Address
WHERE City = @City
GO
