Viewing 4 posts - 1 through 4 (of 4 total)
I tried to run
ALTER TABLE MyTable
ADD RandomNum INT NOT NULL
DEFAULT FLOOR(RAND(CAST(NEWID() AS VARBINARY(36)))*3.0)+1
on SQL Server 2005!
It works well!
Thanx,
December 19, 2005 at 9:11 am
Thank you Jeff for taking your time for my task. Your solution is very simple and useful! It is probbably night in you cuntry on the other side of the...
December 19, 2005 at 5:09 am
Thanx, it is an idea! Althou it would work very slow, specially if a table has a lot of attributes and a lot of records...
December 18, 2005 at 5:01 pm
Thanx a lot for reply! My task is something like that: I have a table with some (for example 3 FirstName, LastName, Age - this is just the example) attributes...
December 18, 2005 at 2:46 pm
Viewing 4 posts - 1 through 4 (of 4 total)