Search code examples
sqlsql-servert-sqlstring-constant

SQL Single quote and double quote inserting values


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


Solution

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

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