Single quote paste problem MSSQL
What I believe you're talking about is Microsoft Office changing single quotes to Smart Quotes.

It's an Autoformatting setting that you can change through the Options menu in Microsoft Word.

Go to Options -> Proofing -> Autocorrect Options

There are two places to change this:


Under 'Autoformat', untick Replace -> Straight Quotes with Smart Quotes
Under 'Autoformat as you type', untick Replace as you Type -> Straight Quotes with Smart Quotes


Alternatively, stop copying SQL from Microsoft Word.

https://www.simple-talk.com/blogs/2011/11/09/how-to-stop-office-2010-changing-and-to-smart-quotes/