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;
