topic RE: GO Keyword of Sql query is not working in Blueprism in Product Forum

GO Keyword of Sql query is not working in Blueprism

Soumya21 — Wed, 19 Apr 2023 04:53:00 GMT

Hi,

I want to execute SQL query in blueprism in that GO statement is there when I execute through blueprism I am getting error incorrect statement near GO. One query which have more queries which separated by GO,
SO GO Statement must be there in query. Can anyone help me to resolve this?

Thanks,
Soumya

------------------------------
Soumya k RPA Developer
RPA Developer
Qualesce India Private Limited
Bangalore
------------------------------

RE: GO Keyword of Sql query is not working in Blueprism

Babjee24 — Wed, 19 Apr 2023 05:23:00 GMT

Hi Soumya,

Attaching a link with info of GO Command Info it says GO is not an T-SQL statement but it's a command that is recognised by sqlcmd and osql. Hence, if we make use of GO command it gives you an error.

------------------------------
Babjee Vangipurapu
Senior RPA Developer
Wonderbotz
India
------------------------------

RE: GO Keyword of Sql query is not working in Blueprism

Soumya21 — Wed, 19 Apr 2023 06:17:00 GMT

Hi @Babjee Vangipurapu
How to make This GO keyword to work in blueprism. or any alternative keyword which needs to be used in replace of GO keyword?

Thanks,
Soumya

------------------------------
Soumya k RPA Developer
RPA Developer
Qualesce India Private Limited
Bangalore
------------------------------

RE: GO Keyword of Sql query is not working in Blueprism

Asilarow2 — Wed, 19 Apr 2023 08:51:00 GMT

Hi Soumya,
GO only relates to SQL Server management Studio (SSMS) - it isn't actual Transact SQL
This is only used in SSMS to send the SQL statements between each GO within batches sequentially.

------------------------------
Andrzej Silarow
Managing Director
Optinex
Leeds
------------------------------