PDA

View Full Version : Syntax error...WTF?


CarlMartin10
08-11-2010, 03:23 AM
ok, I am using SQL Server Management Studio, and things are going well.....then this happened.

I am getting a syntax error, which makes no sense to me, so I thought I might try on here.

I am trying to add these 3 pieces (1 row) of data into a database table called "Shippers"

My code:
USE Northwind;
INSERT INTO shippers VALUES (‘4’, ‘Kaplan Express’, ‘(954)2029000’);

The error:
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '‘'.



Any ideas what the error is here? I am not seeing it.

Fou-Lu
08-11-2010, 04:02 AM
If thats exactly what you have, its likely because of the non-standard quotations (which the error also indicates).
Use a simple text editor like notepad to change them back and save it. Never use word or anything like that >.<