SQL CREATE PROCEDURE 关键字
CREATE PROCEDURE
The CREATE PROCEDURE command is used to create a stored procedure.
A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again.
The following SQL creates a stored procedure named "SelectAllCustomers" that selects all records from the "Customers" table
示例
CREATE PROCEDURE SelectAllCustomers
AS
SELECT * FROM Customers
GO;
Execute the stored procedure above as follows
示例
EXEC SelectAllCustomers;
