Simple pass thru query to Oracle

• Phunhog

  SSCommitted

  Points: 1562

  More actions

  August 20, 2012 at 7:46 am

  #280374

  Hello Oracle Forum:

  I've got my first linked server established from SQL Server 2008 SSMS to Oracle.

  What is the proper syntax for this simple query with a date expression in the where clause?

  What is the proper date delimiter?

  Is there a conversion necessary?

  SELECT TOP (5) SURGERY_DATE

  FROM OPENQUERY(CLARITY, 'SELECT * FROM OR_LOG WHERE SURGERY_DATE = ('8/1/2012')' AS a

  Many thanks ahead of time.

  Phunhog

• PaulB-TheOneAndOnly

  SSC Guru

  Points: 66772

  More actions

  August 20, 2012 at 3:50 pm

  #1527882

  Cross post, please answer here: http://www.sqlservercentral.com/Forums/Topic1347483-1044-1.aspx

  _____________________________________
  Pablo (Paul) Berzukov

  Author of Understanding Database Administration available at Amazon and other bookstores.

  Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.