成功执行 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> [ ,......
既存のプロシージャーを置換するには、ステートメントの許可 ID が既存のプロシージャーの所有者でなければなりません (SQLSTATE 42501)。 グループ特権は、CREATE PROCEDURE (SQL) ステートメントで指定された表やビューに対しては考慮されません。 構...
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 复制 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 ] [ WITH <procedure_option> [ ,...n ] ] [...
syntaxsql Kopie 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> [ ,.....
syntaxsql Copy 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 MESSAGE TYPE (Transact-SQL) CREATE PARTITION FUNCTION (Transact-SQL) CREATE PARTITION SCHEME (Transact-SQL) CREATE PROCEDURE (Transact-SQL) CREATE QUEUE (Transact-SQL) CREATE REMOTE SERVICE BINDING (Transact-SQL) CREATE RESOURCE POOL (Transact-SQL) ...
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...