set?
Thank you for your help
John C
From: Arjan Hulshoff [EMAIL PROTECTED]
To: John c [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: RE: MSSQL to MySQL mapping
Date: Thu, 11 Aug 2005 09:20:08 +0200
Have you adjusted your queries? MSSQL uses a different dialect (T-SQL),
then MySQL
Also mysql complaints when I use the *= syntax:
select a.userID from USers a, UserGroups b where
a.UserGroupID*=b.UserGroupID;
Any ideas? What is the equivalent syntax for MySQL.
Thank you
John C
From: John c [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: FW: RE: MSSQL to MySQL
statements in
MySQL. And if there is, what tool shall I use to change the sql_mode?
Thank you
John C.
From: Rajesh Mehrotra [EMAIL PROTECTED]
To: John c [EMAIL PROTECTED],mysql@lists.mysql.com
Subject: RE: RE: MSSQL to MySQL mapping
Date: Mon, 22 Aug 2005 09:49:32 -0400
User % instead
We have a web based application running on IIS 5.0 using MS SQL Server 2000
as the DBMS; we use ODBC to connect to the DB. We migrated our DB to MySQL
and used the MySQL ODBC driver. It appears that some of the SQL statements
that are accepted by SQL Server 2000 are not accepted by MySQL. Is
We have a web application that uses SQL statements and interacts via an ODBC
interface to MS SQL Server. When we changed the DBMS to MySQL some of the
SQL statements are not accepted by MySQL. Is there a mapping between MSSQL
to MySQL statements?
Thank you
John C.