INSERT INTO TABLE1 (NUMBER1,TEXT1) VALUES (1,'This's my sample')
==> INSERT INTO TABLE1 (NUMBER1,TEXT1) VALUES (1,'This''s my sample')
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')
