max-depth annotation is a positive integer (1 to 50) that indicates the number of recursions: A value of 1 stops the recursion at the element for which the sql:max-depth annotation is specified; a value of 2 stops the recursion at the next le...
ReplicationMaxTextSize 属性 ReplicationXPsEnabled 属性 ScanForStartupProcedures 属性 Server 属性 ServerTriggerRecursionEnabled 属性 ServiceName 属性 ServiceStartMode 属性 SetWorkingSetSize 属性 ShowAdvancedOptions 属性 SmoAndDmoXPsEnabled 属性 SqlDomainGroup 属性 SqlMailEnabled 属性 TcpEnabled...
SQL Másolás EXEC sp_describe_first_result_set @tsql = N' IF (1 = 1) SELECT b FROM t1; ELSE SELECT d AS b FROM t2;'; Here's a partial result set.Táblázat kibontása ColumnValue name b system_type_name varchar max_length 20 is_nullable 1...
Transact-SQL 语法约定语法复制 sys.dm_exec_describe_first_result_set(@tsql, @params, @include_browse_information) 参数@tsql 一个或多个 Transact-SQL 语句。 Transact-SQL_batch 可以是 nvarchar(n) 或 nvarchar(max)。@params...
13 SQL:BatchStarting Occurs when a Transact-SQL batch has started. 14 Audit Login Occurs when a user successfully logs in to SQL Server. 15 Audit Logout Occurs when a user logs out of SQL Server. 16 Attention Occurs when attention events, such as client-interrupt requests or broken client ...
Conventions de la syntaxe Transact-SQLSyntaxeCopier sys.dm_exec_describe_first_result_set(@tsql, @params, @include_browse_information) Arguments@tsql Une ou plusieurs instructions Transact-SQL. Transact-SQL_batch peut être de type nvarchar(n) ou nvarchar(max)....
( STALE_QUERY_THRESHOLD_DAYS = number ) | DATA_FLUSH_INTERVAL_SECONDS = number | MAX_STORAGE_SIZE_MB = number | INTERVAL_LENGTH_MINUTES = number | SIZE_BASED_CLEANUP_MODE = { AUTO | OFF } | QUERY_CAPTURE_MODE = { ALL | AUTO | CUSTOM | NONE } | MAX_PLANS_PER_QUERY = number |...
server_uuid default_storage_engine ob_enable_rich_error_msg cte_max_recursion_depth regexp_stack_limit regexp_time_limit event_scheduler log_row_value_options ob_max_read_stale_time parallel_degree_policy parallel_degree_limit parallel_min_scan_time_threshold optimizer_dynamic_sampling runtime_filte...
server_uuid default_storage_engine ob_enable_rich_error_msg cte_max_recursion_depth regexp_stack_limit event_scheduler regexp_time_limit log_row_value_options ob_max_read_stale_time parallel_degree_policy parallel_degree_limit parallel_min_scan_time_threshold optimizer_dynamic_sampling runtime_...
SQL 型 V3.2.4 使用指南 系统参考 系统变量(Oracle 模式) character_set_server 更新时间:2024-12-26 23:00:00 character_set_server 用于设置服务器字符集。 属性描述 参数类型string 默认值utf8mb4 取值范围 utf8mb4 binary gbk gb18030 utf16