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 l...
Transact-SQL (T-SQL) Reference Date & time hierarchyid methods (database engine) Numeric String & binary Spatial geography & instances (geography Data Type) Spatial geometry & instances (geometry Data Type) Data types XML DBCC Functions Language elements Queries Statements Statements General ALTER APP...
SQL Másolás EXEC sp_describe_first_result_set @tsql = N' DECLARE @SQL NVARCHAR(max); SET @SQL = N''SELECT a FROM t1 WHERE 1 = 1''; IF (1 = 1) SET @SQL += N'' AND e > 10''; EXEC(@SQL);'; This results in an error. The result isn't discove...
ReplicationMaxTextSize 属性 ReplicationXPsEnabled 属性 ScanForStartupProcedures 属性 Server 属性 ServerTriggerRecursionEnabled 属性 ServiceName 属性 ServiceStartMode 属性 SetWorkingSetSize 属性 ShowAdvancedOptions 属性 SmoAndDmoXPsEnabled 属性 SqlDomainGroup 属性 SqlMailEnabled 属性 TcpEnabled...
Created 9 months, 1 week ago Modified 9 months, 1 week ago Type article Status active License CC BY-SA / Gnu FDL History Comments Edit Attachments No attachments exist Error CodeSQLSTATEErrorDescription 1456HY000ER_SP_RECURSION_LIMITRecursive limit %d (as set by the max_sp_recursion_depth var...
Sets database options in Microsoft SQL Server, Azure SQL Database, and Azure Synapse Analytics. For other ALTER DATABASE options, see ALTER DATABASE.Note Setting some options with ALTER DATABASE might require exclusive database access. If the ALTER DATABASE statement doesn't complete in a timel...
Active Directory Stored Procedures (Transact-SQL) Catalog Stored Procedures (Transact-SQL) Change Data Capture Stored Procedures (Transact-SQL) Cursor Stored Procedures (Transact-SQL) Data Collector Stored Procedures (Transact-SQL) Database Engine Stored Procedures (Transact-SQL) Database Mail and SQL ...
optimizer_use_sql_plan_baselines parallel_max_servers parallel_servers_target performance_schema plugin_dir query_cache_size query_cache_type read_only recyclebin resource_manager_plan secure_file_priv sql_auto_is_null sql_mode sql_quote_show_create sql_safe_updates sql_select_limit sql_throttle_...
SQL 型 V3.1.5 使用指南 参考指南 系统变量 character_set_database 更新时间:2024-12-14 23:00:00 编辑 character_set_database 用于设置默认数据库的字符集。 属性描述 参数类型string 默认值utf8mb4 取值范围 utf8mb4 binary gbk gb18030 utf16 ...
varbinary(a)tovarbinary(max) sp_describe_first_result_setdoesn't support indirect recursion. Permissions Requires permission to execute the@tsqlargument. Examples Typical examples A. Basic example The following example describes the result set returned from a single query. ...