Post reply

Incorrect syntax near the keyword OPENQUERY

  • September 22, 2004 at 10:41 am

    #60523

    Hello, I'm trying to write an openquery select statement and for some reason I'm getting a syntax error on the line... as far as I can see, the syntax is perfect and the linked server I'm trying to use is valid and I'm able to access it.  Can anybody see something I'm doing wrong?

    Thanks!

    select * OPENQUERY(NDW2,'SELECT * FROM NORSNAPADM.SALE_CHNL_ITM_LINK')

  • September 22, 2004 at 11:04 am

    #524033

    Make sure NDW2 is your linked server. And you forget keyword from, try this:

    select * From OPENQUERY(NDW2,'SELECT * FROM NORSNAPADM.SALE_CHNL_ITM_LINK') AS T1

     

  • September 22, 2004 at 11:09 am

    #524034

    LOL, duh!  Thank you!  Needed another pair of eyes!

  • September 22, 2004 at 11:23 am

    #524037

    Edited.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply