What is store Procedure?
Course- SQL Sever Store Procedure >
If you want to learn stor procedure(SP),first you should have knowledge of SQL DATABASE.
- Store Procedure(SP) is a Group of SQL Statements
- Stored procedures are executable server-side routines. They give you great power and perfor-
mance benefits if used wisely.
- Stored Procedures return read only data and can have
> Input parameters
> Output parameters
> Parameters that are th input and output
> Can have 1 or more recordsets
St Stored procedures also provide many important performance benefits. By default, a stored
pro pro cedure will reuse a previously cached execution plan, saving the CPU resources and the
ti na me it takes to parse, resolve, and optimize your code. Network traffic is minimized by short-
ening the code strings that the client submits to Microsoft SQL Server—the client submits only
the stored procedure’s name and its arguments, as opposed to the full code. Moreover, all the
act acti ivity is performed at the server, avoiding multiple roundtrips between the client and the
se rver.