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 NU
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
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 s
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 work
