What is stored procedure in sql server

A stored procedure in SQL Server is a group of one or more Transact-SQL statements.

Stored procedure syntax:

CREATE PROCEDURE procedure_name
AS
sql_statement
GO;

Execute Stored procedure :

EXEC procedure_name