To escape a single quote in Sql Server, use two single quotes. Note, don't use a double quote.
For example, the following SQL Script will give error.
Error: 105 Unclosed quotation mark after the character string '
To fix the error mentioned above, escape single quotes with two single quotes as displayed in following example.