一、建立Store Procedure:
CREATE PROCEDURE dbo.sp_who AS SELECT FirstName, LastName FROM Person.Contact;
二、執行Store Procedure:
EXEC dbo.sp_who; EXECUTE dbo.sp_who; --這也是可以
包含參數:
CREATE PROCEDURE HumanResources.uspGetEmployees @LastName nvarchar(50), @FirstName nvarchar(50) AS SET NOCOUNT ON; SELECT FirstName, LastName, JobTitle, Department FROM HumanResources.vEmployeeDepartment WHERE FirstName = @FirstName AND LastName = @LastName;
執行:
EXECUTE HumanResources.uspGetEmployees N'Ackerman', N'Pilar'; --或是 EXEC HumanResources.uspGetEmployees @LastName = N'Ackerman', @FirstName = N'Pilar';
三、修改Store Procedure:
四、刪除Store Procedure:
DROP PROCEDURE dbo.sp_who;