Search code snippets, questions, articles...

MSSQL query to insert value which contains apostrophe or single quote

To insert a value which contains apostrophe or single quote in it, we can use extra single quote with the apostrophe as shown in the below code example.
INSERT INTO table_name (title)
VALUES ('My pet''s name is Rockey');
Best JSON Validator, JSON Tree Viewer, JSON Beautifier at same place. Check how cool is the tool

Search Index Data (The code snippet can also be found with below search text)

insert apostrophe SQL server query
Was this helpful?
0 Comments