Correct syntax for using SQL queries

[Lahiru.Fernando]

@mgeatches

the syntax any different when hitting a view instead of a table?

Nope. Syntax are the same for tables and views.

Have a look at this as well…

Select querry in SQL Server using Execute Command

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 fails, please help ! Thank you !

Also try giving the table names within square brackets

[Mydb].[dbo].[table]

If you have SQL server management studio, try running the same query there as well to get it validated to make sure it’s running. So that we can easily identify whether it’s a problem with the query or with UiPath