Re: A way to transfer a query string for SQL Server to one for another database?

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

From: Peter Rilling (peter_at_nospam.rilling.net)
Date: 02/22/05 

Date: Tue, 22 Feb 2005 13:30:59 -0800

SQL is a standards language and therefore you should be able to use the same
query on any relational database, assuming you are not using any MS
proprietary extensions. All you have to do is to use the SqlCommand object
on a different IConnection object.

For instance, "select * from myTable" should work for all database.

"Quentin Huo" <q.huo@manyworlds.com> wrote in message
news:u9#$wSSGFHA.628@TK2MSFTNGP15.phx.gbl...
> Hi:
>
> If I have a query string for retrieving data from SQL Server database, is
> there a way to transfer it to a query string for retrieving data from
Oracle
> or any other database like mySQL...? I mean by a program. I am working on
> C#.
>
> Thanks
>
> Q.
>
>

Relevant Pages

  • Re: complex filter and calculations in access
    ... switch to SQL view. ... query by switching to datasheet view, ... of your database using the from address in this post. ... pre-op infections yes/no ...
    (microsoft.public.access.queries)
  • Re: A little more meat this week
    ... implementation with a query processor capable of returning a result set ... then we can call it a result bag (SQL ... I'm looking at the data model and not database tools at this ... for a s/w developer and a s/w developer simplifies for the end user). ...
    (comp.databases.pick)
  • Re: complex filter and calculations in access
    ... when using a subquery on the same table as the main query, ... switch to SQL view. ... of your database using the from address in this post. ...
    (microsoft.public.access.queries)
  • Re: A little more meat this week
    ... said data includes lists." ... implementation with a query processor capable of returning a result set ... then we can call it a result bag (SQL ... I'm looking at the data model and not database tools at this ...
    (comp.databases.pick)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)