Not always are comments in SQL shown as such.
When I type this:
...
INNER JOIN #JoinTable JT -- Here I am commenting, but this won't be shown
ON ST.column = JT.column -- This line will be shown as comment, OK
...
The second line of comment ("-- This line will be shown as comment, OK") is colored green nicely and also in italic.
The first line of comment ("-- Here I am commenting, but this won't be shown") won't be marked and shown as such.
I noticed that removing the # will make the comment mark up return, but of course I would like this to always be shown, also when I use a # to mark a temporary table.
Could you improve this?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
(How) can I fix this for the SQL language I use?
Can I create a User Defined Language deducted from the currently implemented SQL language and throw away the # recognition and treatment?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
As mentioned before, the SQL markup language/syntax highlighting is not correct.
When there is a # in the line, anything behind it gets no mark-up at all, while in fact it should.
# is used as a prefix for temporary tables. It has no meaning as a comment statement or anything like that.
Could you please fix this?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This is not completely correct. In MySQL, the # DOES indicate a comment. In Just about all other SQL implementations, the # is normally an escape character. In MSQL (Microsoft's), the # is used to specify an alias name such as:
…WHERE[ WITH(<columns>) AS #<alias_name>]
[,WITH(<columns>) AS #<alias_name>]
Pick your poison here. The correct comment characters are:
-- for single line comments
and
/* for multi-line comments
such as this*/
Bob
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I know about the comment characters. I am indeed using MSQL.
I didn't realize there were multiple SQL layouts. I couldn't get that from the single available SQL language mark up.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Not always are comments in SQL shown as such.
When I type this:
...
INNER JOIN #JoinTable JT -- Here I am commenting, but this won't be shown
ON ST.column = JT.column -- This line will be shown as comment, OK
...
The second line of comment ("-- This line will be shown as comment, OK") is colored green nicely and also in italic.
The first line of comment ("-- Here I am commenting, but this won't be shown") won't be marked and shown as such.
I noticed that removing the # will make the comment mark up return, but of course I would like this to always be shown, also when I use a # to mark a temporary table.
Could you improve this?
(How) can I fix this for the SQL language I use?
Can I create a User Defined Language deducted from the currently implemented SQL language and throw away the # recognition and treatment?
As mentioned before, the SQL markup language/syntax highlighting is not correct.
When there is a # in the line, anything behind it gets no mark-up at all, while in fact it should.
# is used as a prefix for temporary tables. It has no meaning as a comment statement or anything like that.
Could you please fix this?
This is not completely correct. In MySQL, the # DOES indicate a comment. In Just about all other SQL implementations, the # is normally an escape character. In MSQL (Microsoft's), the # is used to specify an alias name such as:
…WHERE[ WITH(<columns>) AS #<alias_name>]
[,WITH(<columns>) AS #<alias_name>]
Pick your poison here. The correct comment characters are:
-- for single line comments
and
/* for multi-line comments
such as this*/
Bob
I know about the comment characters. I am indeed using MSQL.
I didn't realize there were multiple SQL layouts. I couldn't get that from the single available SQL language mark up.