SQL

sql escape quote

DECLARE @my_table TABLE (
    [value] VARCHAR(200)
)

INSERT INTO @my_table VALUES ('hi, my name''s tim.')

SELECT * FROM @my_table

escape qouble quotes SQL

"I asked my son's teacher, "How is my son doing now?""

how to escape single quotes in SQL

The simplest method to escape single quotes in SQL is to use two single quotes. For example, if you wanted to show the value O’Reilly, you would use two quotes in the middle instead of one.
the next method is to add a backslash () before the single quote.