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');