??
字號:
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
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -