sql server escape single quote
DECLARE @text as NVARCHAR(400) SET @text = 'I'm Still Studying.' SELECT @text
The above code gives error
Incorrect syntax near 'm'
Escaping the quote
Put an extra quote in front of that word. Now is recognized the whole thing as a text value like below.
sql escape single quote
DECLARE @text as NVARCHAR(400) SET @text = 'I''m Still Studying.' SELECT @text
I'm Still Studying.
- The doubling up of the quote should have worked.