| title | sys.dm_pdw_nodes_exec_sql_text (Transact-SQL) | Microsoft Docs | |
|---|---|---|
| description | Dynamic management view that returns the text of the SQL batch that is identified by the specified sql_handle. | |
| ms.custom | ||
| ms.date | 10/14/2019 | |
| ms.prod | sql | |
| ms.technology | data-warehouse | |
| ms.reviewer | ||
| ms.topic | language-reference | |
| dev_langs |
|
|
| ms.assetid | ||
| author | XiaoyuMSFT | |
| ms.author | xiaoyul | |
| monikerRange | =azure-sqldw-latest || = sqlallproducts-allversions |
[!INCLUDEtsql-appliesto-xxxxxx-xxxx-asdw-xxx-md]
Returns the text of the SQL batch that is identified by the specified sql_handle. This table-valued function replaces the system function fn_get_sql.
| Column name | Data type | Description |
|---|---|---|
| pdw_node_id | int | Unique numeric ID associated with the node. |
| dbid | smallint | ID of database. For unplanned and prepared SQL statements, the ID of the database where the statements were compiled. |
| objectid | int | ID of object. Is NULL for ad hoc and prepared SQL statements. |
| number | smallint | For a numbered stored procedure, this column returns the number of the stored procedure. For more information, see sys.numbered_procedures (Transact-SQL). Is NULL for ad hoc and prepared SQL statements. |
| encrypted | bit | 1: SQL text is encrypted. 0: SQL text is not encrypted. |
| text | nvarchar(max) | Text of the SQL query. Is NULL for encrypted objects. |
The same remarks in sys.dm_exec_sql_text apply.
Require sysadmin server role or VIEW SERVER STATE permission on the server.
SQL Data Warehouse and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)
For more development tips, see SQL Data Warehouse development overview.