Error Number: 46010 about sqlservermetadata HOT 5 CLOSED

The Parser that is being used is Microsoft's Parser that SSDT uses.
There are a number of bugs within that Parser that have been fixed over time, but this project hasn't been updated to use the fixed parser.
eg.
https://developercommunity.visualstudio.com/t/ssdt-incorrectly-highlighting-syntax-issue-sql4601/790403
And this one is still open:
https://developercommunity.visualstudio.com/t/iif-in-codition-sql46010-incorrect-syntax-near/1578715

Without an example of an SQL Statement that is causing the issue to be raised, I'm unable to confirm this.

from sqlservermetadata.

I've assumed that the issue is ODBC call's to stored procedures.
This is fixed in https://github.com/keif888/SQLServerMetadata/releases/tag/v0.28.0.0-beta

from sqlservermetadata.

Thank you . I will check today. Have been just snowed under with work :-) Thanks again. Much appreciated.

from sqlservermetadata.

Thank you. I have reinstalled - still getting some errors. Will look if i can do some analysis later today. From just watching the parsing - it might queries running on Oracle. Let me do some work on this. Thank you once again.

from sqlservermetadata.

Checked - it seems it is an issue with our scripts. "SQL Server does not support CURRENT_DATE function" A lot of our devs are previous Oracle devs and use "current_date" everywhere :-) Thank you for all the effort on your side.

from sqlservermetadata.