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.
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.