To answer your questions:
a) does MySQL have a T-SQL parser: no
b) is there a compatibility mode that MySQL can run so that valid ANSI SQL
statements will perform on MySQL the same way as they should perform on MS
SQL Server: yes.
c) How do you set the compatibility mode discussed in b):
http://dev.mysql.com/doc/mysql/en/server-options.html
http://dev.mysql.com/doc/mysql/en/server-sql-mode.html (look for
the MSSQL option)
d) does this compatibility mode mean that MySQL now "understands" T-SQL:
No. it means that MySQL will now behave similarly to MS SQL Server for the
commands it can parse. No proprietary MS SQL conventions will work,
however, most ANSI SQL commands will (depending on your version). This
means that the nonstandard "*=" form of creating an OUTER JOIN is still
not supported but the ANSI form of LEFT JOIN or RIGHT JOIN is supported
and I know from personal experience that MS SQL Server can handle that
type of JOIN definition.
e) is there a translation tool to convert proprietary T-SQL commands into
universally accepted ANSI SQL commands: I don't know
Unfortunately, you are discovering just how not-standards-compliant MS SQL
server really is. It lets you get away with murdering the SQL dialect and
still have "valid" queries. Conversion can be easy or hard depending on
how "ANSI" your SQL is to begin with.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"John ccccc" <[EMAIL PROTECTED]> wrote on 08/22/2005 04:04:58 PM:
>
> 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]
>
