SQL Sequence is a feature supported by some database systems to produce unique and automatically incrementing value on demand.
In this article Syntax Arguments Remarks Metadata Show 3 more Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Modifies the arguments of an existing sequence object. If the sequence was created with theCACHEoption, altering the sequence will recreate the cache. ...
Transact-SQL 語法慣例 語法 syntaxsql複製 CREATESEQUENCE[schema_name. ]sequence_name[AS[built_in_integer_type| user-defined_integer_type] ] [STARTWITH<constant>] [INCREMENTBY<constant>] [ {MINVALUE[<constant>] } | {NOMINVALUE} ] [ {MAXVALUE[<constant>] } | {NOMAXVALUE} ] [CYC...
The JDBC driver supports function escape sequences in SQL statements with the following syntax: SQL {fn functionName} wherefunctionNameis a function supported by the JDBC driver. For example: SQL SELECT{fnUCASE(Name)}FROMEmployee The following table lists the various functions that are supported ...
Contact Us Documentation Console Sign In Sign Up All Documentation GaussDB What's New Function Overview Product Bulletin Service Overview Billing Getting Started Kernel Versions User Guide Developer Guide Distributed_3.x Centralized_3.x Distributed_2.x ...
Transact-SQL syntax conventionsSyntaxsyntaxsql Kopírovať CREATE SEQUENCE [schema_name . ] sequence_name [ AS [ built_in_integer_type | user-defined_integer_type ] ] [ START WITH <constant> ] [ INCREMENT BY <constant> ] [ { MINVALUE [ <constant> ] } | { NO MINVALUE } ] [ {...
Transact-SQL syntax conventionsSyntaxsyntaxsql העתק CREATE SEQUENCE [schema_name . ] sequence_name [ AS [ built_in_integer_type | user-defined_integer_type ] ] [ START WITH <constant> ] [ INCREMENT BY <constant> ] [ { MINVALUE [ <constant> ] } | { NO MINVALUE } ] [...
After a sequence is created, you can access its values in SQL statements with the CURRVAL pseudocolumn, which returns the current value of the sequence, or the NEXTVAL pseudocolumn, which increments the sequence and returns the new value. See Also: Pseudocolumns for more information on using...
Once a sequence is created, you can access its values in SQL statements with theCURRVALpseudocolumn, which returns the current value of the sequence, or theNEXTVALpseudocolumn, which increments the sequence and returns the new value. See Also: ...
syntaxsql 复制 sp_sequence_get_range [ @sequence_name = ] N'sequence_name' , [ @range_size = ] range_size , [ @range_first_value = ] range_first_value OUTPUT [ , [ @range_last_value = ] range_last_value OUTPUT ] [ , [ @range_cycle_cou...