Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2
  1. #1
    Regular Coder
    Join Date
    Apr 2010
    Posts
    207
    Thanks
    30
    Thanked 0 Times in 0 Posts

    Syntax error...WTF?

    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:
    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.
    Website: www.billboardfamily.com
    Twitter: www.twitter.com/billboardfamily
    Facebook Fan Page: www.facebook.com/BillboardFamily
    Facebook (Carl): www.facebook.com/CarlMartin.BillboardFamily (admin note: sig should be <=4 lines)

  • #2
    God Emperor Fou-Lu's Avatar
    Join Date
    Sep 2002
    Location
    Saskatoon, Saskatchewan
    Posts
    16,987
    Thanks
    4
    Thanked 2,660 Times in 2,629 Posts
    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 >.<
    PHP Code:
    header('HTTP/1.1 420 Enhance Your Calm'); 

  • Users who have thanked Fou-Lu for this post:

    CarlMartin10 (08-18-2010)


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •