SQL Server Query - Insert problem

Question

I'm having a problem with an insert query in SQL Server. The full text of the query is

insert into franchise (fran_id, name, address1, address2, city, state, zip, email, phone, text) 
values(0, "DevFranchise1", "101 Main St.", "-", "Brighton", "Mi", "48116", "[email protected]", 8105551234, "asdflkjsadf");

Now "state" and "text" both highligh blue. It gives me a list of errors like the following:

Msg 207, Level 16, State 1, Line 1
Invalid column name 'DevFranchise1'
Msg 207, Level 16, State 1, Line 2
Invalid column name '101 Main St.'

What does this mean / how can I fix it?

Thorarin · Accepted Answer · 2010-01-07 15:15:32Z

5

String literals should be in single quotes ('), not double quotes (").

Additionally, right angled brackets ([]) will allow you to use keywords (such as state and text) as column names. This is not always necessary, but provides a way out in ambiguous situations.

insert into franchise
    (fran_id, name, address1, address2, city, [state], zip, email, phone, [text])
values
    (0, 'DevFranchise1', '101 Main St.', '-', 'Brighton', 'Mi', '48116',
    '[email protected]', 8105551234, 'asdflkjsadf');

edited Jan 7, 2010 at 15:15

answered Jan 7, 2010 at 15:10

Thorarin

48.8k12 gold badges77 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Bob Pusateri Over a year ago

and in the future I'd avoid using any keywords as a column name. If it turns blue like you describe, you know something is up...

Josh K Over a year ago

Thanks for the help guys, my first time working on an IIS server.

Peter Lang · Accepted Answer · 2010-01-07 15:07:01Z

5

Try to use single quotes (') instead of double (").

Otherwise, your values seem to be considered as column names.

answered Jan 7, 2010 at 15:07

Peter Lang

55.7k29 gold badges153 silver badges165 bronze badges

Comments

Younes · Accepted Answer · 2010-01-07 15:07:48Z

2

use Single quotes and it will probably work.

answered Jan 7, 2010 at 15:07

Younes

4,8334 gold badges41 silver badges68 bronze badges

Comments

cdonner · Accepted Answer · 2010-01-07 15:06:49Z

1

You have to use single quotes in SQL.

answered Jan 7, 2010 at 15:06

cdonner

37.8k22 gold badges111 silver badges155 bronze badges

Comments

Hogan · Accepted Answer · 2010-01-07 15:07:30Z

1

Use the single quote character not the double quote character in SQL

answered Jan 7, 2010 at 15:07

Hogan

70.7k10 gold badges83 silver badges119 bronze badges

Comments

guille · Accepted Answer · 2010-01-07 16:06:05Z

1

set quoted_identifier off

before the insert.

But better is use single quotes.

answered Jan 7, 2010 at 16:06

guille

2561 silver badge3 bronze badges

Collectives™ on Stack Overflow

SQL Server Query - Insert problem

6 Answers 6

2 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

2 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related