syntaxsql 複製 CREATE [ OR ALTER ] { PROC | PROCEDURE } [schema_name.] procedure_name [ ; number ] [ { @parameter_name [ type_schema_name. ] data_type } [ VARYING ] [ NULL ] [ = default ] [ OUT | OUTPUT | [READO
SQL-control-statementALLOCATE CURSOR-陳述式ALLOCATE DESCRIPTOR-陳述式ALTER FUNCTION-陳述式ALTER MASK-陳述式ALTER PERMISSION-陳述式ALTER PROCEDURE-陳述式ALTER SEQUENCE-statementALTER TABLE-陳述式ALTER TRIGGER-陳述式ASSOCIATE LOCATORS-陳述式COMMENT-陳述式COMMIT 陳述式CONNECT 陳述式CREATE ALIAS-陳述式CREATE FUNCT...
Identifies the parameter as an input parameter to the procedure. Any changes made to the parameter within the procedure are not available to the calling SQL application when control is returned. The default is IN. OUT Identifies the parameter as an output parameter that is returned by the proced...
成功执行 CREATE PROCEDURE 语句后,过程名称将存储在sysobjects系统表中,而 CREATE PROCEDURE 语句的文本将存储在syscomments中。第一次执行时,将编译该过程以确定检索数据的最佳访问计划。 使用cursor 数据类型的参数 存储过程只能将cursor数据类型用于 OUTPUT 参数。如果为某个参数指定了cursor数据类型,也必须指定 VARYING ...
syntaxsql 复制 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> [ ,......
--SQL Server 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 ] ] [ ...
--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 WORKLOAD GROUP (Transact-SQL) CREATE XML SCHEMA COLLECTION (Transact-SQL) CRYPT_GEN_RANDOM (Transact-SQL) CURRENT_REQUEST_ID (Transact-SQL) CURRENT_TIMESTAMP (Transact-SQL) CURRENT_USER (Transact-SQL) cursor (Transact-SQL) CURSOR_STATUS (Transact-SQL) ...
When you nest stored procedure calls, all the procedures must be created in the same transaction mode. TheSECURITY DEFINERoption andSET configuration_parameteroption are not supported when creating a procedure in NONATOMIC mode. Any cursor that is opened (explicitly or implicitly) is closed automatica...
CREATE PROCEDURE 可定义新存储过程。CREATE OR REPLACE PROCEDURE 将创建新的存储过程或替换现有定义。 如果包括 schema 名称,则在指定的 schema 中创建存储过程。否则在当前 schema 中创建。新存储过程的名称不得与同一 schema 中具有相同输入参数类型的任何现有存储过程匹配。不过,具有不同输入参数类型的存储过程可共用...