I want to add parameters arguments of execute query from variable which have dynamics value. I have created two input variables for dynamic column name “allCol” & dynamic column values “allVal”.
Please find the attached screenshot.
Can you add some more details? I am not able to interpret your question clearly.
The tables are dynamic of sql server database, the number of columns and datatypes are varying so I make variable for array of dynamic column names and datatypes but stuck at PARAMETER Argument of Insert query which can’t accept the variable which we have created for dynamic array