SQL

[Raj]

How to Create Dynamic and static connection With SQL?

[gawa]

hi @Raj 

I couldn't understand the meaning of "Dynamic and Static" but if you try to send dynamic query to single SQL server, you can use Dynamic Input tool.

First prepare template SQL query like this(in this case, I will modify where clause x value )

This case, by using x column value, where clause is replaced with "x=1", "x=2"...and get output.

As the above workflow only works at my computer, so sorry for not attaching as a sample.

[Raj]

what if i want to change the data set basis of condition?

[gawa]

I'm sorry, can you describe more detail on what you want to realize?