^^ title... In MS Access I have the option to "increment" or "randomize"... I was wondering how I would have sql server randomize an auto-identity field.
Ok, here is what you can do. You will probably need to create a new column for your identifier. When doing it from Enterprise Manager, choose uniqueidentifier for the column type. When you do that, EM will set the default value for the column to be the newid() T-SQL function. Then set the Is RowGuid property to Yes and you will be set. Use EM to define the column as the primary key column.
With this you will have 16 bit generated values for your column that are guaranteed to be unique.
Topic Locked
Posted - 07 January 2005 : 21:28:56
