CREATE PROC [ EDURE ]procedure_name[;number] [ { @parameter data_type} [ VARYING ] [=default] [ OUTPUT ] ] [,...n] [ WITH { RECOMPILE | ENCRYPTION | RECOMPILE,ENCRYPTION } ] [ FOR REPLICATION ] ASsql_statement[ ...n] 参数 procedure_name 新存储过程的名称。过程名必须符合标识符规...
对于CREATE PROCEDURE (SQL) 语句中指定的任何表或视图,不会考虑组特权。 语法 CREATEOR REPLACEPROCEDUREprocedure-name(,INOUTINOUTparameter-namedata-typedefault-clause)option-listSQL-procedure-body data-type built-in-typeanchored-variable-data-typearray-type-namecursor-type-namedistinct-type-namerow-type-...
@parameter = default 輸出 數據表值參數類型 CURSOR VARYING 使用預存程序修改資料 UPDATE 錯誤處理 TRY...CATCH 模糊化程序定義 WITH ENCRYPTION 強制程序重新編譯 WITH RECOMPILE 設定安全性內容 EXECUTE AS 基本語法 本節的範例使用所需的最少語法示範 CREATE PROCEDURE 陳述式的基本功能。 A. 建立 Transact-...
使用CREATE PROCEDURE 语句创建存储过程 CREATEPROCEDURE[schema_name.] 存储过程名 [; number ] {@parameterdata_type } [VARYING] [=default] [OUT|OUTPUT ] [READONLY] [WITH<ENCRYPTION JI[ RECOMPILE ]I[EXECUTEASClause ]>] [FORREPLICATION]ASBEGIN-- SQL语句return@参数2;-- 可以不返回END procedure_...
CREATE PROCEDURE|PROC [<parameter name> <data type> [VARYING][<default value>] [OUTPUT]], [<parameter name> <data type> [VARYING][<default value>] [OUTPUT]] [...,n] [WITH PECOMPILE|ENCRYPTION|EXECUTE AS{ CALLER |SELF|OWNER|<'user name '>}] [ FOR REPLICATION] AS...
CREATE [ OR ALTER ] { PROC | PROCEDURE } [schema_name.] procedure_name [ ; number ] [ { @parameter_name [ type_schema_name. ] data_type } [ = default ] [ OUT | OUTPUT ] [READONLY] ] [ ,...n ] [ WITH EXECUTE AS Clause ] AS { EXTERNAL NAME assembly_name.class_name.meth...
--Transact-SQL Stored Procedure Syntax CREATE { PROC | PROCEDURE } [schema_name.] procedure_name [ ; number ] [ { @parameter [ type_schema_name. ] data_type } [ VARYING ] [ = default ] [ OUT | OUTPUT ] [READONLY] ] [ ,...n ] [ WITH <procedure_option> [ ,...n ] ] [...
CREATE PROC [ EDURE ] procedure_name [ ; number ] [ { @parameter data_type } [ VARYING ] [ = default ] [ OUTPUT ] ] [ ,...n ] [ WITH { RECOMPILE | ENCRYPTION | RECOMPILE , ENCRYPTION } ] [ FOR REPLICATION ] AS sql_statement [ ...n ] ...
CREATE [ OR ALTER ] { PROC | PROCEDURE } [schema_name.] procedure_name [ ; number ] [ { @parameter_name [ type_schema_name. ] data_type } [ VARYING ] [ NULL ] [ = default ] [ OUT | OUTPUT | [READONLY] ] [ ,...n ] [ WITH <procedure_option> [ ,...n ] ] [ FOR ...
-- call the stored procedure with 'USA' as parameter valueCALLctr_customers ('USA');-- call the same stored procedure again with another parameter value 'UK'CALLctr_customers ('UK'); Multiple Parameterized Procedures A stored procedure can also take multiple parameters. For example, ...