8.1创建存储过程 CREatE ProcedUre的语法形式如下: CREATE(PROCPROCEDUREJ [schema name ] procedure name; number K@parameter[type schema name. data typel TVARYINGIdefault[[OUT[PUTILn WITH<procedure option>L.n] [FOR REPLICATION] AS k<sql statement>[[ n]<method specifier>l; procedure option>∷ TENCRYPTIONIRECOMPILE]EXECUTE AS Clause] sql statement>∷= I BEGIN] statements [ENDI] <method specifier>: :=EXTERNAL NAME assembly name class name. method_ name SQL SERVER2005入门与实例教程电子工业出版社20068.1 创建存储过程 •CREATE PROCEDURE的语法形式如下： CREATE {PROC|PROCEDURE} [schema_name.]procedure_name[;number] [{@parameter[type_schema_name.] data_type} [VARYING][=default][[OUT[PUT]][,...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