Tag: "single quote"

How to assign a text containing a single quote to a char, varchar, nchar or nvarchar valiable or colum

Sometimes the need to assign a text like "She's the boss" to a text column or variable arises.DECLARE @MyText AS NVARCHAR(100) = 'She's the boss'; You can already see on the syntax coloring that something is wrong. To put a single quote inside a stri… more »