Database stored procedure

What is a database stored procedure?

In fact, the definition is very simple: it is a defined SQL code that can be called repeatedly
We can also define stored procedures that can accept parameters, so that we can deal with requirements more flexibly.

grammar

CREATE PROCEDURE procedure_name
AS
sql_statement
GO;

EXEC procedure_name;

example

CREATE PROCEDURE SelectAllCustomers
AS
SELECT * FROM Customers
GO;

EXEC SelectAllCustomers;