SQL Server doesn't support the "IF EXISTS" clause. There are also differences in data types.
On 1/23/08, J Trahair <[EMAIL PROTECTED]> wrote: > > 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/ -- Sincerely yours, Olexandr Melnyk <>< http://omelnyk.net/
