simple question for damn SQL-Server
Posted on 2003-03-06
I already discovered that SQL statements like "alter table messages modify email char(35);" have to be changed to "alter table messages alter column email char(35);" for Transact-SQL to understand them :/
And also that parentheses are not welcome in such a statement : "alter table status add (MsgToDo smallint default 1,StatsToDo smallint default 1,CleanToDo smallint default 1);"
I also discovered I had to type "go" ("go, go, Goldorak go" :D ) a zillion times to make MS-SQL Server to process my statements 8-)) How marvelous 8-))
My question is now "how to make a UNIQUE field auto-incrementable" ? as this doesnt work in Transact-SSL (thank you Billou) :
create table activite (id integer unique auto_increment,ip char(15));