来自「JAVA下的SQL_System的建立」· 代码 · 共 38 行

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 存储过程可以通过以下方法执行：
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'