I reckon a new version has been installed (I figure that happens automatically, rather than as an explicit action)
My guess is that has caused the formatting of single quotes
' to change to "pretty quotes".
Seen several recent posts now where the O/P has NOT formatted their code, and all the single-quotes have been mangled.
But I don't remember that being an issue in the past.
FWIW I find it hugely tedious that no newcomers on this site format their code. Clearly they have no idea how to do that, which is a failing of the software (not following the older conventions, and it not being apparent to the O/P that they must use MARKDOWN [which i hate, as you will have gathered )
Then the Forum software tries to interpret other stuff (for MARKDOWN) and mangles
<word> with angle-brackets (I've deliberately escaped that) and anything with
_ - all of which occur in SQL Code and succumb to being mangled - if not formatted.
Newbeis need to be directed to a How to Post page that explains what they need to do. I'm happy to write some content if that would be helpful. Once they've posted its too late ... all of us start wasting time guessing what the O/P might have Cut & Pasted or, in current example, we are providing solutions with wrong quotes - ` instead of
' (I don't even know HOW to highlight the first of those two without the Forum "eating" it) and then the O/P copies and pastes into SSMS and it doesn't work (and they are clearly too thick to work out that its a Quotes issue - although in fairness with many fonts the difference between ` and ' is hard to see)
Can anything be done?