What is the best way to store a Sql query and its parameters?

Although we can store the entire Query in Config File, how can it really help with Parameters that we pass ?
What is the best way to store it ? Any ideas are greatly appreciated.

1 Like

Hi @GSR

You can read this article for your reference. This might be helpful to you.

cheers :smiley:

Happy learning :smiley:

3 Likes

@GSR

You can try using ā€˜@parameterNameā€™ statement in the sql command.
select coulmns/* from @table where column = @parameterName
Reference : https://docs.uipath.com/activities/docs/execute-query