Insert signgle quote into MS SQL Server

INSERT INTO TABLE1 (NUMBER1,TEXT1) VALUES (1,’This’s my sample’) ==> INSERT INTO TABLE1 (NUMBER1,TEXT1) VALUES (1,’This”s my sample’)
Read more »INSERT INTO TABLE1 (NUMBER1,TEXT1) VALUES (1,’This’s my sample’) ==> INSERT INTO TABLE1 (NUMBER1,TEXT1) VALUES (1,’This”s my sample’)
Read more »