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
Olexandr Melnyk <><