hi , i want to pass the dynamic values in SQL server from UiPath, [dbo].[PriorClaimsSearch_Demographics] "KIARA ",“WILLMS”,“199212”,“32197”,“6413”,“GA”,“kha”,“TriTerm Medical” from "KIARA to Medical " all the values are dynamic plz help.

@Neha_Aggarwal1 Yes this is how you would assign the variables and the values needs to be assigned either in assign activity…or needs to be taken from some where before coming to this activity If you have a user input then you can add Input dialog boxes and assign outputs to variables there cheer…

@Neha_Aggarwal1 Use variables inplace of them.are you facing any issue if you do so? Cheers

@Anil_G not having clarity how to do this …m using execute query for this

@Neha_Aggarwal1 In execute query where you give the query …you will see a plus icon…click on the plus icon and click on advanced editor… In that "[dbo].[PriorClaimsSearch_Demographics]""" + variable1 + """,“WILLMS”,“199212”,“32197”,“6413”,“GA”,“kha”,“TriTerm Medical” Like this Basically a string…

[image] As in screenshot u find now i am passing the the hardcoded value in parameter, this I want to change dynamically

@Neha_Aggarwal1 Awesome if you have already added parameters…then instead of your hardcoded values assign variables there…nothing else changes…parameters need not be changed If you already have variables assign them If you want to run in loop then use currentrow("Columnname").ToString Cheers

[image] like this i have given the variable name only (without using any assign activity with variable name and its value)

if i give assign activity with variable name and its value then also it act as a constant value only …i want dynamic value

Hi @Neha_Aggarwal1 , Check this below link, [image] How to pass a variable in an SQL query Help Thanks I found a link in which they explained how to use insert for Mysql. Below are the detals, it worked for me If you want to parameterize and avoid SQL injection attacks…

How to pass the dynamic value in SQL from uipath

Help StudioX

Manish540 (Manish Shettigar) March 15, 2023, 12:43pm 10

Hi @Neha_Aggarwal1 ,

Check this below link,

Hope this might help you

Topic		Replies	Views
How To Pass Dynamic Data To SQL Query From UiPath? Knowledge Base activities	6	9187	December 21, 2022
Change static data from to Variable in SQL Query Insights question	3	263	December 11, 2025
How to supply Parameter's in PostgreSQL Activities datatable , excel , database , activities , studio , question , sql-database	17	2186	July 14, 2023
How to pass string value as parameter in sql squer? Studio studio , question , workflow_diff	5	1584	April 14, 2023
How to Pass variable to sql execute query? Help datatable , database , uiautomation , variable	36	35839	October 10, 2018

How to pass the dynamic value in SQL from uipath

Related topics