[mssql] Create Table query

[Pieman]

Hi,

For the first time in my life I'm using mssql, I'm currently trying to create a table, with a query but apparently mssql has a different syntax as mysql.

Could someone tell me what's wrong with this query:

CREATE TABLE rageweb (
    id int(32) NOT NULL auto_increment,
    news_text TEXT NOT NULL default '',
    author varchar(20) NOT NULL default '',
    subject varchar(255) NOT NULL default '',
    date char(19) NOT NULL default '',
    PRIMARY KEY  (id)
) TYPE=MyISAM;

Error message: Msg 102, Level 15, State 1, Line 2
Incorrect syntax near 'auto_increment'.

 

[Daevius]

See this site:

http://girasquid.com/blog/2007/11/01/mssqls-auto_increment-equivalent/

 

[s-p-n]

I'd help the guy out by leaving a 'thank-you' comment as well. That encourages the prolonged use of open-source help on the internet We're putting colleges out of business here =D