SQL CREATE PROCEDURE 关键字
CREATE PROCEDURE
The CREATE PROCEDURE
command is used to create a stored procedure.
存储过程是预先准备好的 SQL 代码,您可以保存它,以便代码可以一次又一次地重用。
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;
如下执行上面的存储过程
示例
EXEC SelectAllCustomers;