Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric SQL database in Microsoft Fabric Query hints specify that the indicated hints are used in the scope of a query. They affect all operators in t...
原始产品版本: SQL Server 联机丛书 原始KB 数: 314520 总结 查询链接服务器时,经常执行使用或OPENROWSETOPENDATASOURCE语句的OPENQUERY直通查询。 可以在 SQL Server 联机丛书中查看示例,了解如何使用预定义的 Transact-SQL 字符串来执行此操作,但没有有关如何将变量传递给这些函数的示例。 本文提供了如何将变量传递给链...
Applies to:SQL ServerAzure SQL DatabaseAzure SQL Managed Instance Creates a user-defined function (UDF), which is a Transact-SQL or common language runtime (CLR) routine. A user-defined function accepts parameters, performs an action such as a complex calculation, and returns the result of ...
Each server in the cluster is monitored by the cluster manager using a heartbeat, so it detects when the active server in the cluster goes offline and attempts to seamlessly switch to the next server in the cluster, although there is a variable time delay as the switch ha...
Applies to:SQL ServerAzure SQL DatabaseAzure SQL Managed Instance Creates a user-defined function (UDF), which is a Transact-SQL or common language runtime (CLR) routine. A user-defined function accepts parameters, performs an action such as a complex calculation, and returns the result of ...
@variable [ OUTPUT ] } } [ ...n ] ] ) [ AS { LOGIN | USER } = ' name ' ] [ AT linked_server_name ] [ AT DATA_SOURCE data_source_name ] [ ; ] <execute_option>::= { RECOMPILE | { RESULT SETS UNDEFINED } | { RESULT SETS NONE } | { RESULT SETS ( <result_sets_...
execute_sql: execute_sql(query: str) -> str - Returns the result of SQL query execution, args json schema: {"query": {"title": "Query", "description": "SQL query to execute", "type": "string"}} 2. get_table_columns: get_table_columns(database: str, table: str) -> str - ...
STATE_STORE_NULL_TYPE_ORDERING_COLS_NOT_SUPPORTED、STATE_STORE_UNSUPPORTED_OPERATION_ON_MISSING_COLUMN_FAMILY、STATE_STORE_VARIABLE_SIZE_ORDERING_COLS_NOT_SUPPORTED、UDTF_ALIAS_NUMBER_MISMATCH、UDTF_INVALID_ALIAS_IN_REQUESTED_ORDERING_STRING_FROM_ANALYZE_METHOD、UDTF_INVALID_REQUESTED_SELECTED_EXPRESSION_FRO...
Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance Analytics Platform System (PDW) SQL database in Microsoft Fabric This article helps you decide when and how to perform index maintenance. It covers concepts such as index fragmentation and page density, and their impact on ...
Run stored procedures. If the SQL statement invokes a stored procedure that returns results from a temporary table, use the WITH RESULT SETS option to define metadata for the result set. Save the rowset returned from a query into a variable. ...