Value.NativeQuery
Assesses the query against a specified target using the parameters and options provided. The result of the query is determined by the target, which sets the context for the query operation. The query ...
Value.NativeQuery(target as any, query as text, optional parameters as any, optional options as nullable record) as anyAssesses the query against a specified target using the parameters and options provided. The result of the query is determined by the target, which sets the context for the query operation. The query itself is a specific expression related to the target, such as a T-SQL statement.
The optional parameters value can include a list or record to supply the necessary parameter values for the query. The optional options record may contain specific options that impact how the query is evaluated against the target. These options are tailored to the target's requirements.