SQL Server 和 Azure SQL Database 中預存程序的 Transact-SQL 語法: syntaxsql 複製 CREATE [ OR ALTER ] { PROC | PROCEDURE } [schema_name.] procedure_name [ ; number ] [ { @parameter_name [ type_schema_name. ] data_type } [ VARYING ] [ NULL ] [ = default ] [ OUT | OUTPUT ...
CREATE CURSOR - SQL CommandArticle 11/14/2006 Creates a temporary table. Copy CREATE CURSOR alias_name (fname1 type [(precision [, scale])] [NULL | NOT NULL] [CHECK lExpression [ERROR cMessageText]] [AUTOINC [NEXTVALUE NextValue [STEP StepValue]]] [DEFAULT eExpression] [UNIQUE [...
syntaxsql 复制 <order_clause> ::= { <column_name_in_clr_table_type_definition> [ ASC | DESC ] } [ , ...n ] <method_specifier> ::= assembly_name.class_name.method_name <clr_function_option> ::= { [ RETURNS NULL ON NULL INPUT | CALLED ON NULL INPUT ] | [ EXECUTE_AS_Claus...
syntaxsql 複製 <order_clause> ::= { <column_name_in_clr_table_type_definition> [ ASC | DESC ] } [ , ...n ] <method_specifier> ::= assembly_name.class_name.method_name <clr_function_option> ::= { [ RETURNS NULL ON NULL INPUT | CALLED ON NULL INPUT ] | [ EXECUTE_AS_Claus...
SQL Reference SQL Keywords Data Type Constant and Macro Functions and Operators Expressions Pseudocolumn Type Conversion System Operation Controlling Transactions DDL Syntax Overview DML Syntax Overview DCL Syntax Overview SQL Syntax SQL Syntax ABORT ALTER AUDIT POLICY ALTER COLUMN ENCRYPTION KEY ...
--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 ] ] [...
PL/SQL User's Guide and ReferenceorOracle9i Java Stored Procedures Developer's Guidefor more information on such prerequisites Syntax create_function::= Text description of create_function (invoker_rights_clause::=,parallel_enable_clause::=) ...
If you run flows using the command line interface and want to override the current (default) parameter values, create a parameters override .json file and include the -p --parameters syntax in your command line. For more information, see Refresh flow output files from the command line. Run ...
适用于: SQL Server Azure SQL 数据库 Azure SQL 托管实例创建用于将查询提示或实际查询计划与数据库中的查询关联的计划指南。 有关计划指南的详细信息,请参阅 Plan Guides。Transact-SQL 语法约定语法syntaxsql 复制 sp_create_plan_guide [ @name = ] N'name' [ , [ @st...
For more information about SQL Server system data types and their syntax, see Data Types (Transact-SQL). Table-valued or cursor data types can't be used as parameters. If the data type of the parameter is a CLR user-defined type, you must have EXECUTE permission on the type. VARYING ...