= ALTER DATABASE SET HADR <mixed_page_allocation_option> ::= MIXED_PAGE_ALLOCATION { OFF | ON } <parameterization_option> ::= PARAMETERIZATION { SIMPLE | FORCED } <query_store_options> ::= { QUERY_STORE { = OFF [ ( FORCED ) ] | = ON [ ( <query_store_option_list> [,...n]...
FORCED SQL Server 对数据库中的所有查询进行参数化。 可通过查看 is_parameterization_forced 目录视图中的 sys.databases 列确定此选项的当前设置。 <query_store_options> ::= 展开表 适用范围:SQL 数据库 V12。 备注 目前这是预览功能。若要使用查询存储,你必须确认并同意查询存储的实现符合你的许可协议(例如...
要在数据库级别设置它,可使用下列命令: ALTER DATABASE AdventureWorks2008 SET PARAMETERIZATION SIMPLE ALTER DATABASE AdventureWorks2008 SET PARAMETERIZATION FORCED 允许带引号的标识符 默认情况下,SQL Server使用方5.SQL Server 2008 新建数据库配置参数 SQL Server 2008 数据库 数据库是SQL Server 2008的核心,它可...
<parameterization_option> ::=控制參數化選項。PARAMETERIZATION { SIMPLE | FORCED } SIMPLE 根據資料庫的預設行為,將查詢參數化。如需詳細資訊,請參閱<簡單參數化>。 FORCED SQL Server 會將資料庫中的所有查詢參數化。如需詳細資訊,請參閱<強制參數化>。 您可以檢查 sys.databases 目錄檢視中的 is_...
| <database_mirroring_option> | <date_correlation_optimization_option> | <db_encryption_option> | <db_state_option> | <db_update_option> | <db_user_access_option> | <external_access_option> | <parameterization_option> | <recovery_option> ...
<database_mirroring_option>|<date_correlation_optimization_option>|<db_encryption_option>|<db_state_option>|<db_update_option>|<db_user_access_option>|<delayed_durability_option>|<external_access_option>|<FILESTREAM_options>|<HADR_options>|<parameterization_option>|<query_store_options>|<recovery...
The database remains in SINGLE_USER mode even if the user that set the option logs off. At that point, a different user, but only one, can connect to the database. Before you set the database to SINGLE_USER, verify the AUTO_UPDATE_STATISTICS_ASYNC option is set to OFF. When set to...
The database remains in SINGLE_USER mode even if the user that set the option logs off. At that point, a different user, but only one, can connect to the database. Before you set the database to SINGLE_USER, verify the AUTO_UPDATE_STATISTICS_ASYNC option is set to OFF. When set to...
ParameterizationAlterDatabaseOption 型別會公開下列成員。 方法 展開表格 名稱說明 Accept 指定之訪客的進入點。 (覆寫 TSqlFragment.Accept(TSqlFragmentVisitor)。) AcceptChildren 在具有指定之訪客的子系上呼叫 Accept。 (覆寫 AlterDatabaseOption.AcceptChildren(TSqlFragmentVisitor)。) Equals 判斷指定的 Object...
{ <db_state_option> | <db_user_access_option> | <db_update_option> | <external_access_option> | <cursor_option> | <auto_option> | <sql_option> | <recovery_option> | <database_mirroring_option> | <service_broker_option> | <date_correlation_optimization_option> | <parameterization_...