USE pubs
IF EXISTS (SELECT name FROM member 
         WHERE name = 'userinformation' AND type = 'P')
   DROP PROCEDURE userinformation
GO
USE pubs
GO
CREATE PROCEDURE userinformation 
   @lastname varchar(40), 
   @firstname varchar(20) 
AS 
SELECT lastname, fristname, 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
   WHERE  au_fname = @firstname
      AND au_lname = @lastname
GO
userinformation 存儲過程可以通過以下方法執(zhí)行：
EXECUTE userinformation 'Yuguang', 'Fu'
-- Or
EXECUTE userinformation @lastname = 'Yuguang', @firstname = 'Fu'
-- Or
EXECUTE userinformation @firstname = 'Fu', @lastname = 'Yuguang'
-- Or
EXEC userinformation 'Yuguang', 'Fu'
-- Or
EXEC userinformation @lastname = 'Yuguang', @firstname = 'Fu'
-- Or
EXEC userinformation @firstname = 'Fu', @lastname = 'Yuguang'
如果該過程是批處理中的第一條語句，則可使用：
userinformation 'Yuguang', 'Fu'
-- Or
userinformation @lastname = 'Yuguang', @firstname = 'Fu'
-- Or
userinformation @firstname = 'Fu', @lastname = 'Yuguang'