i would like to create an int with autoincrement in my table, in mySQL i could do this with AUTO_INCREMENT but in Microsoft SQL it doesn't work.
What should i use in MS SQL.
CREATE TABLE nuke_stories_cat
(
catid int NOT NULL AUTO_INCREMENT,
title varchar(20) NOT NULL,
counter int DEFAULT(0) NOT NULL
PRIMARY KEY(catid)
)
thx
