sys.fn_stmt_sql_handle_from_sql_stmt

Description

2016 (13.x) and later versions SQL database in Microsoft Fabric for a Transact-SQL statement under the given parameterization type (simple or forced). You can refer to queries stored in the Query Store by using their The text of the query in the Query Store that you want the handle of. The parameter type of the query.

Syntax

sys.fn_stmt_sql_handle_from_sql_stmt (
N
'query_sql_text'
, [ query_param_type ]
)
[ ; ]

Examples

Example 1

sys.fn_stmt_sql_handle_from_sql_stmt

Example 2

statement_sql_handle

Example 3

query_sql_text

Example 4

query_parameterization_type

Example 5

0

Example 6

1

Example 7

EXECUTE

Example 8

DELETE

Example 9

sys.fn_stmt_sql_handle_from_sql_stmt

Example 10

SELECT
*
FROM sys.databases;

(. and 1 more examples)