Hi, Could someone explain me how can I select query in SQL Server. I entered the connection string and tried different select methods like : 1 → SELECT col1,col2 FROM [dbo].[table] WHERE col3 > 50 2 ->SELECT [col1] ,[col2] FROM [dbo].[table] WHERE col 2>50 GO Nothing works. The query fail…

Select querry in SQL Server using Execute Command

rpa.serban (Popa Serban Alexandru) May 13, 2017, 7:29pm 6

Hi,
Check if the connection is still open, or somewhere on the line you closed the connection, for me that was the issue .
Hope this may help you ! ( also if the connection is not open then the query won’t work)

Regards,
Serban

1 Like

Select query in Uiapth to retrieve data from database

Topic		Replies	Views
Execute Query activity within a If activity Studio studio , question , activities_panel	4	814	March 24, 2022
Correct syntax for using SQL queries Help	12	9166	March 10, 2020
Execute SQL Query Help database , activities , question	1	1906	January 26, 2021
Not able to fetch proper result with query Help activities	3	1211	November 21, 2018
Multiple values in SQL for Execute Query to excel Activities datatable , excel , activities , executequery	9	707	December 15, 2022

Most Active Users - Yesterday
ashokkarale
MD_Farhan1
Ajay_Mishra
postwick
Dheerendra_vishwakarma
Anil_G
chandreshsinh.jadeja
Gautham_Pattabiraman
vrdabberu
aravindbalineni123
More details...

Select querry in SQL Server using Execute Command

Related Topics