sys.dm_pdw_nodes_exec_sql_text (Transact-SQL)
Applies to: Azure Synapse Analytics
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
.
Note
This syntax is not supported by serverless SQL pool in Azure Synapse Analytics.
Table returned
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 improvised 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 improvised 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. |
Remarks
The same remarks in sys.dm_exec_sql_text apply.
Permissions
Require sysadmin server role or VIEW SERVER STATE
permission on the server.
See also
Azure Synapse Analytics and Parallel Data Warehouse Dynamic Management Views (Transact-SQL)
Next steps
For more development tips, see Azure Synapse Analytics development overview.