sql
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');
Was this helpful?
Similar Posts