sp in sql server
Stored procedure
A sp is group of T-SQL statement. If you have any kind of situation, where you are writing the
same query over and over again, you can save that specific query as a
stored procedure and then just call by it's name. Basically wrapped this query into sp, and just call that sp.
e.g.
CRETAE PROCEDURE Procedure_Name
AS
BEGIN
SQL Statement
END