What about DROP TABLE IF EXISTS TableName and CREATE TABLE NewTableName... and ALTER TABLE TableName ADD COLUMN DeliveryNoteNumber INT NOT NULL DEFAULT 0
Thanks Jonathan Trahair 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/
