Re: ASP/Access query syntax question

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Kevin Spencer (kevin_at_takempis.com)
Date: 02/25/04 

Date: Wed, 25 Feb 2004 08:54:19 -0500

Hi Larry,

There are indeed places where the SQL Syntax of various databases can be
found. However, I know of no one place where the syntax for ALL of them can
be found. So, if you'll tell me what database product you're using (via this
NG, not by private emial, please), I'll help you with your query. 

-- 
HTH,
Kevin Spencer
.Net Developer
Microsoft MVP
Big things are made up
of lots of little things.
"bender" <larry@netgeexdotcom> wrote in message
news:5l9o305sq9p5nm69fim57tbigl900rp2sp@4ax.com...
> I used to know this, but now I've forgotten.
>
> Using the NOT LIKE, if I want to end a query with "...WHERE country
> NOT LIKE 'USA' "
>
> what characters do I put around USA to make this work?  And isn't
> there a good reference page somewhere on the 'net that shows these
> syntax things all together for MS SQL and Access, etc.?
>
> thanks
>
> Larry
> - - - - - - - - - - - - - - - - - -
> "Forget it, Jake. It's Chinatown."

Relevant Pages

  • Re: Books/References new to scripting in AD/2003
    ... Good luck with your scripting - It's a worthwhile pursuit and the time you spend learning to script can easily be re-paid. ... I don't believe there is any way to test bits of flag attributes like userAccountControl using SQL syntax. ... but needs to be enclosed in quotes in a query. ...
    (microsoft.public.windows.server.scripting)
  • Re: Books/References new to scripting in AD/2003
    ... my own website has lots of script samples you might find useful: ... test bits of flag attributes like userAccountControl using SQL syntax. ... To restrict the query to an OU, ...
    (microsoft.public.windows.server.scripting)
  • Re: PreparedStatement + "order by ?"
    ... Is there a way to use a PreparedStatement with a query such as ... The query seems to properly compile and execute, ... are not a general-purpose placeholder for whatever bit of SQL syntax you ... wouldn't be portable to most other databases. ...
    (comp.lang.java.programmer)
  • Re: Books/References new to scripting in AD/2003
    ... Good luck with your scripting - It's a worthwhile pursuit and the time you spend learning to script can easily be re-paid. ... I don't believe there is any way to test bits of flag attributes like userAccountControl using SQL syntax. ... but needs to be enclosed in quotes in a query. ...
    (microsoft.public.windows.server.scripting)
  • Re: Update Query Syntax
    ... Now get the message when running: "Operation must use an updateable query". ... I'd like some help on the SQL Syntax or preferably, ... Use a query to select/sum data to then update data in another table. ...
    (microsoft.public.access.queries)