List:General Discussion« Previous MessageNext Message »
From:Olexandr Melnyk Date:January 23 2008 5:10pm
Subject:Re: MySQL and MS SQL Server 2005
View as plain text  
Most of the
basic statements should work fine on both, but here are several points
you should keep in mind:

- SQL Server doesn't support LIMIT clause;
- Don't use quotes for numerical values as it works on MySQL only;
- In GROUP BY clause, list all not aggregated columns you are selecting;
- Use single quotes for strings;

Hope it helps.

On 1/23/08, J Trahair <j.trahair@stripped> wrote:
>
> Hi Everyone
>
> I am now familiar with connecting with MySQL using Visual Basic 6 and ADO.
> I am about to start a new project which must connect to a customer's MS SQL
> Server 2005 installation.
>
> How safe/unsafe is my assumption that as far as SQL strings and ADO
> connections are concerned 'if it works on MySQL it will work on MS SQL
> Server 2005'?
>
> The SQL strings I use are the really simple ones eg.
> INSERT INTO...,
> UPDATE FROM...,SET...WHERE...
> SELECT FROM...WHERE...ORDER BY...
>
> Thanks in advance.
>
> Jonathan Trahair




-- 
Sincerely yours,
Olexandr Melnyk <><
http://omelnyk.net/

Thread
MySQL and MS SQL Server 2005J Trahair23 Jan
  • Re: MySQL and MS SQL Server 2005Olexandr Melnyk23 Jan
Re: MySQL and MS SQL Server 2005J Trahair23 Jan
  • Re: MySQL and MS SQL Server 2005Olexandr Melnyk23 Jan