Hi

I posted this question on another thread in the Links SQL Discussion but it is probably more relevant to this Forum.

Alex posted the following and it works for others but not me.

UPDATE Users SET Password = FLOOR(RAND() * 10000)


All I get is the same 4 digit number on every record.

I'm on a MS SQL Server, could this be the problem.?

Regards

minesite

I'm not sure about this one. How about something like?


- wil

You should be able to come up with something by reading here:

http://msdn.microsoft.com/...ac_8_con_11_1bl0.asp

Hi Wil

Getting closer but still gives me the same on all records.

Not this but like this:

0.794575



Regards

minesite

Hi,

I don't think you can do this with MS SQL, the RAND() function gets only evaluated once, and then the update happens, whereas in MySQL, the RAND() is evaluated for each row.

You would need to use a script that:

SELECT Username FROM Users

UPDATE Users SET Password = FLOOR(RAND() * 1000) WHERE Username = $username

for each user.

Cheers,

Alex
--
Gossamer Threads Inc.