SQL Store Procedure is a sql statement which perform specific task. Store Procedure is consists of header and body, the header part is consists of the name of the procedure and the parameters or variable passed to the procedure and the body part is a declare section or execution of the store procedure.
There many benefit of using store procedure like it increases the performance of the database, it decrease the amount of data to be send to the sql server etc.
We can pass parameters to procedures in three ways.
Create Procedure Procedure-name ( Input parameters, Output Parameters (If required) ) As Begin Sql statement used in the stored procedure End ->Where Procedure-name is the name of the procedure.
In the table “Person” fields PersonID, First-Name, Last-Named, Phone_No.
Create PROCEDURE Getpersonname ( @PersonID INT --Input parameter, PersonID of the person ) AS BEGIN SELECT First-name+' '+Last-name FROM person WHERE PersonID=@PersonID END