SQL Single quote and double quote inserting values

Question

Im trying to create a table and insert this value here:

("Where I'm Calling From: Selected Stories", 'Raymond', 'Carver', 1989, 12, 526),

Im having an issue with using single and double quotes. How would I amend this ? and what should I keep in mind for future?

Using Microsoft SQL Server management 2014

score 2 · Accepted Answer · answered Feb 26 '19 at 20:27

2

Always use single quote, and double single quote when needed.

('Where I''m Calling From: Selected Stories', 'Raymond', 'Carver', 1989, 12, 526)

answered Feb 26 '19 at 20:27

DanB

score 1 · Answer 2 · answered Feb 26 '19 at 20:27

1

double quotes cannot be used for insert. use single quotes. you can use single quotes twice for escaping. ''

insert into .... values 
 ('Where I''m Calling From: Selected Stories', 'Raymond', 'Carver', 1989, 12, 526)

answered Feb 26 '19 at 20:27

2 Answers2