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 <[EMAIL PROTECTED]> 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/
