StringLiteral SubqueryComparisonPredicate SubqueryComparisonPredicateType SymmetricKeyStatement SystemTimePeriodDefinition SystemVersioningTableOption TableClusteredIndexType TableDataCompressionOption TableDefinition TableDistributionOption TableDistributionPolicy TableElementType TableHashDistributionPolicy ...
StringLiteral SubqueryComparisonPredicate SubqueryComparisonPredicateType SymmetricKeyStatement SystemTimePeriodDefinition SystemVersioningTableOption TableClusteredIndexType TableDataCompressionOption TableDefinition TableDistributionOption TableDistributionPolicy TableElementType TableHashDistributionPolicy TableHint TableHintKind...
SIZE、MAXSIZE 和 FILEGROWTH 属性不适用于 MEMORY_OPTIMIZED_DATA 文件组。 有关内存优化文件组的详细信息,请参阅内存优化文件组。 SIZE size 指定文件大小。 SIZE 不适用于 FILESTREAM 文件组。 size 文件的大小。 与ADD FILE 一起指定时,size是文件的初始大小。 与 MODIFY FILE 一起指定时,size是文件的新大小...
ALTERDATABASESCOPED CONFIGURATIONFORSECONDARYSETLEGACY_CARDINALITY_ESTIMATION = PRIMARY ; D. 设置 PARAMETER_SNIFFING 本示例在异地复制方案中为主数据库将 PARAMETER_SNIFFING 设置为 OFF。 SQL ALTERDATABASESCOPED CONFIGURATIONSETPARAMETER_SNIFFING =OFF;
Character string constants and varbinary constants of size greater than 8000 are treated as type varchar(max) (or nvarchar(max) and varbinary(max), respectively). This can change the data type of the table created using SELECT … INTO if the SELECT list contains such expressions. ...
system_var_name修改租户的系统变量值。 示例 锁定租户tenant1。 obclient>ALTERTENANT tenant1LOCK; 修改租户tenant1的 Primary Zone 为zone2。 obclient>ALTERTENANT tenant1 primary_zone='zone2'; 不可直接替换租户的资源池,否则将出现以下错误。 obclient>ALTERTENANT tenant1 resource_pool_list=('pool2');...
SET 1MAINTAINED BY SYSTEMMAINTAINED BY USERENABLE QUERY OPTIMIZATIONDISABLE QUERY OPTIMIZATION Notes: 1 The same clause must not be specified more than one time. period-definition: SYSTEM_TIME(begin-column-name,end-column-name)BUSINESS_TIME(begin-column-name,end-column-nameEXCLUSIVEINCLUSIVE)Descripti...
SET 1MAINTAINED BY SYSTEMMAINTAINED BY USERENABLE QUERY OPTIMIZATIONDISABLE QUERY OPTIMIZATION Notes: 1 The same clause must not be specified more than one time. period-definition: SYSTEM_TIME(begin-column-name,end-column-name)BUSINESS_TIME(begin-column-name,end-column-nameEXCLUSIVEINCLUSIVE)Descripti...
Use theALTERSESSIONstatement to set or modify any of the conditions or parameters that affect your connection to the database. The statement stays in effect until you disconnect from the database. Prerequisites To enable and disable the SQL trace facility, you must haveALTERSESSIONsystem privilege...
SQLServerResultSetMetaData 弁仿旦 SQLServerSavepoint 弁仿旦 SQLServerStatement 弁仿旦 SQLServerXAConnection 弁仿旦 SQLServerXADataSource 弁仿旦 SQLServerXAResource 弁仿旦 失皿伉弗奈扑亦件及悵荾 由白巧奈穴件旦午陓螸俶及砃奻 觳及偅剿 失皿伉弗奈扑亦件 戊奈玉及扔件皿伙 ...