Way to insert text having ' (apostrophe) into a SQL table

Question

While I was trying the following SQL command , I got sql error.

INSERT INTO exampleTbl VALUES('he doesn't work for me') 

where doesn't contain the apostrophe.

What is the way to insert text having ' (apostrophe) into a SQL table.

Answer 1

In SQL, the way to do this is to double the apostrophe:

'he doesn''t work for me' 

If you are doing this programmatically, you should use an API that accepts parameters and escapes them for you, like prepared statements or similar, rather that escaping and using string concatenation to assemble a query.

Answer 2

INSERT INTO exampleTbl VALUES('he doesn''t work for me') 

If you're adding a record through ASP.NET, you can use the SqlParameter object to pass in values so you don't have to worry about the apostrophe's that users enter in.