ntax especially without
an
> MSSQL to MySQL mapping. Isn't there a mode to support T-SQL 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]>
T-SQL 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]>,
Subject: RE: RE: MSSQL to MySQL mapping
Date: Mon, 22 Aug 2005 09:49:32 -0400
ccc; mysql@lists.mysql.com
Subject: RE: RE: MSSQL to MySQL mapping
User % instead of *
-Original Message-
From: John c [mailto:[EMAIL PROTECTED]
Sent: Monday, August 22, 2005 9:48 AM
To: mysql@lists.mysql.com
Subject: FW: RE: MSSQL to MySQL mapping
Also mysql complaints when I use the
User % instead of *
-Original Message-
From: John c [mailto:[EMAIL PROTECTED]
Sent: Monday, August 22, 2005 9:48 AM
To: mysql@lists.mysql.com
Subject: FW: RE: MSSQL to MySQL mapping
Also mysql complaints when I use the *= syntax:
select a.userID from USers a, UserGroups b where
I set the sql_mode, with what tool, how do I ensure what sql mode is
currently set?
Thank you for your help
John C
From: "Arjan Hulshoff" <[EMAIL PROTECTED]>
To: "John ccccc" <[EMAIL PROTECTED]>
CC:
Subject: RE: MSSQL to MySQL mapping
Date: Thu, 11 Aug 2005
currently set?
Thank you for your help
John C
From: "Arjan Hulshoff" <[EMAIL PROTECTED]>
To: "John c" <[EMAIL PROTECTED]>
CC:
Subject: RE: MSSQL to MySQL mapping
Date: Thu, 11 Aug 2005 09:20:08 +0200
Have you adjusted your queries? MSSQL uses a differe
Have you adjusted your queries? MSSQL uses a different dialect (T-SQL),
then MySQL uses. There are quite some difference, although some queries
still might work.
Arjan.
-Original Message-
From: John c [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 10, 2005 08:12 PM
To: mysql@li
John c wrote:
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 accep
