JAVA下的SQL_System的建立

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