GO Keyword of Sql query is not working in Blueprism

[Soumya21]

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
------------------------------

[Babjee24]

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
------------------------------

[Soumya21]

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
------------------------------

[AndrzejSilarow]

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
------------------------------