Re: FN-FORUM: Autonumber in sql server

date posted 21st January 2007 16:09

Thanks guys, sorted it out now, the properties were locked because i had set
the column as a uniqueidentifier instead of an int. like i said i havent
used SQL Server before (and only am now because of its integration with VB,
still prefer MySQL) and i just assumed that this was the equivalent of
autonumber!

Oh, and whats the best way of storing a string, i'm currently using text
data type but would nchar(10) be better?

Thanks
James