This eliminates any confusion as to which parameter index represents what. This also means that * rearranging the SQL statement or adding a parameter doesn't involve renumbering your indices.

Each parameter marker in an SQL statement must be associated, or bound, to a variable in the application before the statement can be executed. This is done by calling the SQLBindParameter function.

It's your concern to build SQL compliant with your DBMS SQL syntax. It is only intended to be a simple tool to dynamically construct actual SQL querys depending on which input parameters are given or ...

I'm trying to figure out how to use the SQL where/in syntax with a paramterized ... 1,2,3};<BR><BR>cmd.Parameters.Add("@ids", ids);<BR><BR>Then I'd run the query. But this doesn't work.

The great thing about table-valued functions is that they appear in the Navigator pane when you connect to a SQL Server database from the Power Query Editor: You can only hard-code the values you pass ...