MSSQL help w/ auto_increment
| From: | David Orn Johannsson | Date: | Tue, 23 Apr 2002 15:04:45 +0000 |
| Subject: | MSSQL help w/ auto_increment | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-94176@lists.php.net to get a copy of this message | ||
Im having a problem wiht creating a db in MSSQL, Ive only used Mysql
be for so I tryed the syntax just the same way.
Im 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, Ive 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:david@atom.is> david@atom.is
<http://www.atom.is/> http://www.atom.is
------------------------