Hello I have a sql query and this return one column with one value and i want to assign this to a variable any way how to assign it. Reason assign value is failing to me.
Select Top(1) [Id]
From [Test] Where Name=@XXX And DOB=@DOB
Hello I have a sql query and this return one column with one value and i want to assign this to a variable any way how to assign it. Reason assign value is failing to me.
Select Top(1) [Id]
From [Test] Where Name=@XXX And DOB=@DOB
Use Execute Query activity there you have a option to store the result to a datable
For Connecting to SQL server from UiPath, check below documentation
Hope this may help you
Thanks