ALTER SESSION SET INSTANCE statement (Parallel Server Administration, Deployment, and Performance) ALTER SESSION SET ISOLATION_LEVEL=SERIALIZABLE command (Documentation Addendum) [entry #2] (Documentation Addendum) [entry #3] (Migration) ALTER SESSION SET SCHEMA statement (Application Developer's Gu...
syntaxsql Copy -- Syntax for Azure Synapse Analytics and Parallel Data Warehouse ALTER TABLE { database_name.schema_name.source_table_name | schema_name.source_table_name | source_table_name } { ALTER COLUMN column_name { type_name [ ( precision [ , scale ] ) ] [ COLLATE Windows_coll...
Syntax alter_system::= Text description of alter_system archive_log_clause::= Text description of archive_log_clause end_session_clauses::= Text description of end_session_clauses alter_system_set_clause::= Text description of alter_system_set_clause alter_system_reset_clause::=...
syntaxsql复制 ALTEREVENTSESSIONevent_session_nameONSERVER{ [ [ {<add_drop_event>[ ,...n] } | {<add_drop_event_target>[ ,...n ] } ] [WITH(<event_session_options>[ ,...n ] ) ] ] | [STATE= {START|STOP} ] }<add_drop_event>::={ [ADDEVENT<event_specifier>[ ( { [SET{...
syntaxsql コピー ALTER DATABASE { database_name | CURRENT } SET { [ ,...n ] [ WITH <termination> ] } ::= { <accelerated_database_recovery> | <auto_option> | <automatic_tuning_option> | <change_tracking_option> | <containment_option> | <cursor_option> | <database_mirroring...
syntaxsql ALTERDATABASEdatabase_name{<add_or_modify_files>|<add_or_modify_filegroups>}<add_or_modify_files>::={ADDFILE<filespec>[ ,...n ] [TOFILEGROUP{filegroup_name} ] |ADDLOGFILE<filespec>[ ,...n ] |REMOVEFILElogical_file_name|MODIFYFILE<filespec>}<filespec>::=(NAME=logical_file...
ALTER PROCEDURE alters the attributes of a customized stored procedure.Only the owner of a stored procedure or a user granted with the ALTER permission can run the ALTER
可以使用 SET 语句 来为当前会话配置很多数据库 SET 选项,当它们连接时通常通过应用程序来配置。 会话级 SET 选项将覆盖 ALTER DATABASE SET 值。 下面各节中所述的数据库选项是你可以为未明确提供其他 SET 选项值的会话设置的值。 语法 syntaxsql 复制 ALTER ...
syntaxsql Copy -- Syntax for Azure Synapse Analytics and Parallel Data Warehouse ALTER TABLE { database_name.schema_name.source_table_name | schema_name.source_table_name | source_table_name } { ALTER COLUMN column_name { type_name [ ( precision [ , scale ] ) ] [ COLLATE Windows_coll...
可以使用 SET 语句 来为当前会话配置很多数据库 SET 选项,当它们连接时通常通过应用程序来配置。 会话级 SET 选项将覆盖 ALTER DATABASE SET 值。 下面各节中所述的数据库选项是你可以为未明确提供其他 SET 选项值的会话设置的值。 语法 syntaxsql 复制 ALTER DATABASE { database_name | CURRENT } SET {...