Create Procedure – MSDN

以下是MSDN页面的一个例子：

USE AdventureWorks;
GO

-- If procedure exists already,drop it
IF OBJECT_ID ( 'HumanResources.uspGetAllEmployees','P' ) IS NOT NULL 
    DROP PROCEDURE HumanResources.uspGetAllEmployees;
GO

-- Create (or Re-create) the procedure
CREATE PROCEDURE HumanResources.uspGetAllEmployees
AS
    SET NOCOUNT ON;
    SELECT LastName,FirstName,JobTitle,Department
    FROM HumanResources.vEmployeeDepartment;
GO

请记住,创建存储过程后,您必须右键单击 – >刷新存储过程文件夹以显示新的过程.

我还建议将* .sql文件保存在某个位置,以便在需要再次运行时将CREATE PROCEDURE脚本放在某处.