Unfortunately there is a lot of variation from one RDBMS' SQL
implementation to another.
Try something like this:
create table test (
news_id int identity,
title varchar(50), blah blah...
miguel
- Original Message -
From: David Orn Johannsson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 23, 2002 10:04 AM
Subject: [PHP] MSSQL help w/ auto_increment
I'm having a problem wiht creating a db in MSSQL, I've only used Mysql
be for so I tryed the syntax just the same way.
I'm trying to execute this code:
create table test
(
news_id int not null auto_increment
, title varchar(50) not null
, ndate varchar(50) not null
, headline varchar(150) not null
, fullarticle text not null
, lang varchar(50) not null
, PRIMARY KEY(news_id))
But it gives me an error on the auto_increment, which I assume is wrong
for MSSQL, I've been searching the web for any results regarding to this
problem of mine without any luck so I hope you can find it in your heart
to help me if you can :)
Thaks for your time
http://www.atom.is/
Davíð Örn Jóhannssson
Vefforritari
Atómstöðin hf.
Garðastræti 37
101 Reykjavík
sími: 595-3643
fax: 595-3649
mailto:[EMAIL PROTECTED] [EMAIL PROTECTED]
http://www.atom.is/ http://www.atom.is
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php