Muokkaa

Jaa


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.