创建存储过程的方法和创建数据库中任何其他对象一样,除了它使用的AS关键字外。存储过程的基本语法如下:
CREATE PROCEDURE|PROC
[ [schema.] [VARYING] [= ] [OUT[PUT]]
[READONLY]
[, [schema.] [VARYING] [= [OUT[PUT]]
[READONLY]
[, ...
...
]]
[WITH
RECOMPILE| ENCRYPTION | [EXECUTE AS { CALLER|SELF|OWNER|<'user name'>}]
[FOR REPLICATION]
AS
| EXTERNAL NAME ..
基本存储过程的示例:
USE AdventureWorks2008
GO
CREATE PROC spEmployee
AS
SELECT * FROM HumanResources.Employee;