help-bison
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

from ms access SQL syntax to SQL Server SQL sysntax


From: Luis Hernandez
Subject: from ms access SQL syntax to SQL Server SQL sysntax
Date: Thu, 5 Jun 2003 16:16:33 -0700

I’m desperately looking for a utility to convert MS Access SQL statements to SQL Server OR from Oracle to SQL Server.

Example:

From (Jet):    SELECT Choose (T1.SurceType, T1.Name, T2.Name)  FROM Table1 T1, Table2 T2

To (SQLServer):  SELECT Case (T1.SurceType WHEN 1 THEN T1.Name WHEN 2 THEN T2.Name) FROM Table1 T1, Table2 T2

If you know one, let me know please.

 

 


reply via email to

[Prev in Thread] Current Thread [Next in Thread]