SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE <Procedure_Name, sysname, ProcedureName>
--定義輸入/輸出的參數
AS
BEGIN
SET NOCOUNT ON;
--編寫執行命令
END
GO
執行存儲過程 execute proc_name input/output