求大家帮忙
想写一个存储过程,查询的命令是这样的,那位老师帮忙一下。刚接触存储过程。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 { 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