SQL Comment

[sdejager]

Is there a way to add comments in SQL?
Using -- makes the service invoke fail, with message The index .. is out of range.
Without comments the SQL query works as designed.

Kind regards,
SImon

[supandey]

Hi Simon, did you try something like this

/* Get All tables from DB.*/

Select * from tab

At least i use it for the Oracle not sure which DB you running.

[sdejager]

Hello Sushant,

I am using a MS SQL server and using /* My comment */ gives the same error

[supandey]

Simon, I tested it with SQL Server too and it works without any problems. Would it be possible for you to post a sample SQL query you are using with the comment(s)?

BTW i could use the /* bla */ format for commenting while querying the SQL Server table.

[sdejager · Accepted solution]

I have done some more research and it seems to occur when there is the following in the comment:
[[SomeText]]