To create a basic Stored Procedure syntax as follows:
CREATE PROCEDURE | PROC _spName
AS
_SQLQuery;
Created Store procedure can be executed as follows:
A basic Stored Procedure that performs a basic query as example:
USE Pubs
GO
//Create a SP///
CREATE PROCEDURE SP_getaColumnData
AS
SELECT fname FROM employee;
//test SP///
EXEC SP_getaColumnData
fname
--------------------
Aria
Ann
Annette
Anabela
....
....
(43 row(s) affected)