Solved

open query guidlines

Posted on 2011-02-16
5
355 Views
Last Modified: 2012-05-11
is there a difference between the SQL used via linked server (Open Query) than when running a query on the server itself?  As an example where myfielddate >= '2/08/2011' returns an invalid sintax near '2'

0
Comment
Question by:kgittinger
  • 2
  • 2
5 Comments
 
LVL 8

Expert Comment

by:pdd1lan
ID: 34906364
did you try it:?

convert(char(10),myfielddate,103) >= '02/08/2011'
0
 

Author Comment

by:kgittinger
ID: 34908470
Unfortuantely this returns the same error
0
 
LVL 41

Accepted Solution

by:
ralmada earned 500 total points
ID: 34909258
try two consecutive single quotes

myfielddate >= ''2/08/2011''
0
 
LVL 41

Expert Comment

by:ralmada
ID: 34909322
if you still have issues, please post the complete query you're trying to run
0
 

Author Closing Comment

by:kgittinger
ID: 34910668
Thanks a million!
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question