mercredi 7 janvier 2015

Different rand() value for multiple rows SQL Server

When I use this query, it assigns every row to the same value. Is there anyway to make this not happen?



UPDATE Team
SET GroupID = CAST(RAND() * 4 AS INT)




Aucun commentaire:

Enregistrer un commentaire