想写一个存储过程，查询的命令是这样的，那位老师帮忙一下。刚接触存储过程。
select a.xmmc,a.gg,a.sl,a.je,a.je,b.xm
from mz_cfmx a inner join mz_cf b on a.cfbh=b.cfbh
where a.cfbh=''

Create Procedure test(@cfbh varchar(20))
AS
BEGIN
  select a.xmmc,a.gg,a.sl,a.je,a.je,b.xm
  from mz_cfmx a inner join mz_cf b on a.cfbh=b.cfbh
  where a.cfbh=@cfbh
END
看下SQL的帮助就是 你这个很简单的 SQL的帮助功能很强大

语法

CREATE { PROC | PROCEDURE } [schema_name.] procedure_name [ ; number ] 
    [ { @parameter [ type_schema_name. ] data_type } 
        [ VARYING ] [ = default ] [ OUT | OUTPUT ] [READONLY]
    ] [ ,...n ] 
[ WITH <procedure_option> [ ,...n ] ]
[ FOR REPLICATION ] 
AS { <sql_statement> [;][ ...n ] | <method_specifier> }
[;]
<procedure_option> ::= 
    [ ENCRYPTION ]
    [ RECOMPILE ]
    [ EXECUTE AS Clause ]

<sql_statement> ::= 
{ [ BEGIN ] statements [ END ] }

<method_specifier> ::=
EXTERNAL NAME assembly_name.class_name.method_name