CREATE PROC [ EDURE ] procedure_name [ ; number ]
    [ { @parameter data_type }
        [ VARYING ] [ = default ] [ OUTPUT ]
    ] [ ,...n ] 
[ WITH
    { RECOMPILE | ENCRYPTION | RECOMPILE , ENCRYPTION } ] 
[ FOR REPLICATION ] 
AS sql_statement [ ...n ]
在這里創建一個簡單的存儲過程。將從4個表的連接中返回所有用戶名、密碼，以及出生日期。該存儲過程不使用任何參數。
USE pubs
IF EXISTS (SELECT name FROM member 
         WHERE name = 'userdetail' AND type = 'P')
   DROP PROCEDURE userdetail
GO
CREATE PROCEDURE userdetail
AS
SELECT name, password,birthday
   FROM member a INNER JOIN users ta
      ON a.au_id = ta.au_id INNER JOIN titles t
      ON t.title_id = ta.title_id INNER JOIN publishers p
      ON t.pub_id = p.pub_id
GO
userdetail 存儲過程可以通過以下方法執行：
EXECUTE userdetail
-- Or
EXEC userdetail
如果該過程是批處理中的第一條語句，則可使用：
userdetail