How do I insert a string containing a single-quote character?

Question

I have a problem with this insert query in SQL Server 2008

insert into Book values('B0000001I002','C# 3.0: A Beginner's Guide')

How do I make SQL ignore the single-quote in C# 3.0: A Beginner's Guide?

Which language? Or is directly SQL Server? – Eduardo M Jun 03 '13 at 04:31 — Eduardo M, Jun 03 '13 at 04:31

score 7 · Answer 1 · edited May 23 '17 at 12:00

7

This question was asked before and the answer is to escape the ' by doubling it:

INSERT INTO Book VALUES('B0000001I002','C# 3.0: A Beginner''s Guide')

edited May 23 '17 at 12:00

Community

answered Jun 03 '13 at 04:35

Burhan Khalid

Thanks. Sorry about duplicate question but I searched it at google and find nothing – sonas sonas Jun 03 '13 at 04:42

score 0 · Answer 2 · edited May 23 '17 at 11:48

0

you can do it using escape sequence

Check:

edited May 23 '17 at 11:48

Community

answered Jun 03 '13 at 04:32

Anand Shah

score -1 · Answer 3 · answered Jun 03 '13 at 04:31

-1

Try

insert into Book values('B0000001I002','C# 3.0: A Beginner\'s Guide')

answered Jun 03 '13 at 04:31

sarwar026

Whoever gave downvote, please check the answered time, I didn't copy paste from another, I give the answer first and who earn 5 votes, he give the answer4 minutes later! – sarwar026 Oct 16 '16 at 04:08

3 Answers3