SQL server

[cocomy]

Hi All,

I would like to modify SQL statement after getting data.

Can you help me how to change it?

All the best,

cocomy

[v-yulgu-msft · Accepted solution]

Hi @cocomy,

Two ways for your consideration.

1. You can modify SQL statement by clicking on the gear icon on the source Step in the query settings.

2. You can modify the Query parameter in the Advanced editor.

Best regards,

Yuliana Gu

[cocomy]

Hi Yuliana

Thank you very much. I was not aware I had to go to query to amend SQL server.

Thank you again.

All the best,

cocomy