1Stored procedure
2A sp is group of T-SQL statement. If you have any kind of situation, where you are writing the
3same query over and over again, you can save that specific query as a
4stored procedure and then just call by it's name. Basically wrapped this query into sp, and just call that sp.
5
6e.g.
7CRETAE PROCEDURE Procedure_Name
8AS
9BEGIN
10 SQL Statement
11END
12