Hi,
I am used to working on a Unix server using SQL... But right now the site I'm working on is on a Microsft Server using Microsoft SQL... I never really knew if there was much of a difference, but my query which was working fine on the Unix server is giving me errors on the SQL server. It's a create table query. Maybe someone can see the problem right away?
CREATE TABLE jobs (
id int(11) NOT NULL auto_increment,
title varchar(255) NOT NULL default '',
description mediumtext NOT NULL,
qualifications mediumtext NOT NULL,
dateadded int(8) NOT NULL default '0',
acceptingthru int(8) NOT NULL default '0',
contact varchar(255) NOT NULL default '',
phone varchar(255) NOT NULL default '',
email varchar(255) NOT NULL default '',
address mediumtext NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM AUTO_INCREMENT=6 ;
And the error I get is this:
Line 2: Incorrect syntax near 'auto_increment'
I have tried looking up stuff on auto_increment for MS SQL but can't find anything.
Thanks,
Heather