4、执行存储过程 语法: [L EXEC[ UTE ]] @return status=1 I procedure name [; number @procedure name varl [ @parameter=] I value@variable OUTPUT][ DEFAULT] 1 n L WITH RECOMPILE I 2021/2/20 Information College. ChangJun
11 2021/2/20 Information College · ChangJun 4、执行存储过程 语法： [ [ EXEC [ UTE ] ] { [ @return_status = ] { procedure_name [ ;number ] | @procedure_name_var} [ [ @parameter = ] { value | @variable [ OUTPUT ] | [ DEFAULT ] ] [ ,...n ] [ WITH RECOMPILE ]
例1的执行语句: EXECUTE student info all Or EXEC student info all 如果该过程是批处理中的第一条语句,则 可使用: student info all 2021/2/20 Information College. ChangJun
12 2021/2/20 Information College · ChangJun 例1的执行语句： EXECUTE student_info_all -- Or EXEC student_info_all 如果该过程是批处理中的第一条语句，则 可使用： student_info_all