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> [ ,......
成功执行 CREATE PROCEDURE 语句后,过程名称将存储在sysobjects系统表中,而 CREATE PROCEDURE 语句的文本将存储在syscomments中。第一次执行时,将编译该过程以确定检索数据的最佳访问计划。 使用cursor 数据类型的参数 存储过程只能将cursor数据类型用于 OUTPUT 参数。如果为某个参数指定了cursor数据类型,也必须指定 VARYING ...
對於CREATE PROCEDURE (SQL) 陳述式中指定的任何表格或概略表,不會考量群組專用權。語法 CREATEOR REPLACE PROCEDUREprocedure-name(,INOUTINOUTparameter-namedata-typedefault-clause)option-listSQL-procedure-body data-type built-in-typeanchored-variable-data-typearray-type-namecursor-type-namedistinct-type-name...
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...
syntaxsql Copiar 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> [ ,.....
--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 ] ...
To define a column in a table To define a CHECK constraint on a column To replace a stored procedure Use an inline function as a filter predicate for a security policy The integration of .NET Framework CLR into SQL Server is discussed in this article. CLR integration doesn't apply to Azur...
To define a column in a table To define a CHECK constraint on a column To replace a stored procedure Use an inline function as a filter predicate for a security policy The integration of .NET Framework CLR into SQL Server is discussed in this article. CLR integration doesn't apply to Azur...
To define a column in a table To define a CHECK constraint on a column To replace a stored procedure Use an inline function as a filter predicate for a security policy The integration of .NET Framework CLR into SQL Server is discussed in this article. CLR integration doesn't apply to Azur...
To define a column in a table To define a CHECK constraint on a column To replace a stored procedure Use an inline function as a filter predicate for a security policy The integration of .NET Framework CLR into SQL Server is discussed in this article. CLR integration doesn't apply to Azur...