Use variables in SQL querie

[Ashtari (TestBot)]

Hey,
i try to use my variable strInputEmail in my SQL query.

UiPath told me now that i have a syntax error and I dont know why…

My query is
“Select UserID From User WHERE Mail = @strInputEmail”

Every column is correct and the variable name also…

What is the correct syntax to user variables in my queries?

Thanks for your help:-)

[ImPratham45 (Prathamesh Patil)]

Use “+” to use variable in a string say
"My name is "+Var_Name
For strInputEmail this var
“Select UserID From User WHERE Mail = "+strInputEmail

[Srini84 (Srinivas Kadamati)]

@Ashtari

You can pass the variable by using parameters

Hope this helps

Thanks

[Pratik_Wavhal]

Hi @Ashtari

“select * from User”

“select UserID from User WHERE Mail = '”+strInputEmail+“'”

Hope this would solve your issue
Mark as solution and like it.

Happy Automation

Best Regards
Er Pratik Wavhal

[SN2 (Shankar)]

hi @Pratik_Wavhal
I would like to execute the below query
“select distinct a.* from dbo.Required_Skills a left join dbo.Employee_Skills_Details b on a.[Display Expression] = b.[Training Role]
where b.FirstName ='”+fName+“’ or b.LastName ='”+lName+“'”
But getting error. please help on this