Thank you for your e-mail, but it did not work. In any case it does not make
a lot of sense to go back to a 1000 page application and identify every
single T-SQL syntax and convert it to a MySQL syntax 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]>
To: "John ccccc" <[EMAIL PROTECTED]>,<mysql@lists.mysql.com>
Subject: RE: RE: MSSQL to MySQL mapping
Date: Mon, 22 Aug 2005 09:49:32 -0400
User % instead of *
-----Original Message-----
From: John ccccc [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
a.UserGroupID*=b.UserGroupID;
Any ideas? What is the equivalent syntax for MySQL.
Thank you
John C>
>From: "John ccccc" <[EMAIL PROTECTED]>
>To: mysql@lists.mysql.com
>Subject: FW: RE: MSSQL to MySQL mapping
>Date: Mon, 22 Aug 2005 13:18:43 +0000
>
>
>I am trying to adjust sql_mode but with no success. I use MySQL Query
>Browser from a remote mashine, login as root and I run set global
>sql_mode='ansi';
>
>Then I run MySQLCommand line client from the MySQL server and the
>sql_mode is unchanged.
>
>I also tried to set the sql_mode in the My.ini file but it does not
>seem to have any effect. We have a web application that connects to
>MySQL. The applicatio written to communicate to SQL Server and the
>MySQL default mode cannot interpret the sql queries.
>
>How do 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: <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 uses. There are quite some difference, although
>>some queries still might work.
>>
>>Arjan.
>>
>>
>>-----Original Message-----
>>From: John ccccc [mailto:[EMAIL PROTECTED]
>>Sent: Wednesday, August 10, 2005 08:12 PM
>>To: mysql@lists.mysql.com
>>Subject: MSSQL to MySQL mapping
>>
>>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 there a mapping from MSSQL to MySQL statements?
>>
>>Thank you
>>John C.
>>
>>_________________________________________________________________
>>Express yourself instantly with MSN Messenger! Download today - it's
>>FREE!
>>http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>>
>>
>>--
>>MySQL General Mailing List
>>For list archives: http://lists.mysql.com/mysql To unsubscribe:
>>http://lists.mysql.com/[EMAIL PROTECTED]
>>
>>
>>
>>--
>>The information contained in this communication and any attachments is
>>confidential and may be privileged, and is for the sole use of the
>>intended recipient(s). Any unauthorized review, use, disclosure or
>>distribution is prohibited. If you are not the intended recipient,
>>please notify the sender immediately by replying to this message and
>>destroy all copies of this message and any attachments. ASML is
>>neither liable for the proper and complete transmission of the
>>information contained in this communication, nor for any delay in its
receipt.
>>
>>--
>>MySQL General Mailing List
>>For list archives: http://lists.mysql.com/mysql
>>To unsubscribe:
>>http://lists.mysql.com/[EMAIL PROTECTED]
>>
>
>_________________________________________________________________
>Don't just search. Find. Check out the new MSN Search!
>http://search.msn.click-url.com/go/onm00200636ave/direct/01/
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
>
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's
FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
