SQL Dynamic query not working

Question

How can I replace a question mark "?" in a SQL dynamic query with pipeline parameters in Azure Data Factory? When I attempt to pass the parameters, ADF does not recognize the "?" symbol, and the parameters are not correctly passed.

Answer 1

To build a dynamic query, you can either use the concat function to concatenate the query with your parameters, or you can use string interpolation (@{...}). Both methods allow you to construct a query dynamically with parameters having the desired values.

Check this old thread :

https://stackoverflow.com/questions/75590526/sql-dynamic-query-in-adf