I believe the auto increment field has to be set as the primary key as well.

----- 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

Reply via email to