When there's an error in a SEDE query, you just get the error message.
Incorrect syntax near '*'.
This can leave me guessing as to which one of the *
in my query is causing the error.
SSMS seems to be able to give me a line number, so I guess SQL Server is able to provide this info.
Msg 102, Level 15, State 1, Line 4
Incorrect syntax near '5'.
Can this be added?
*
in your queries :)*
is an example. In this particular query I could replace all*
instances with a specific field (I'm doing acount()
), but I would be none the wiser.Incorrect syntax
uniquely identifies the troublesome line