valores random en SQL Server

UPDATE Usuarios Set pin = ABS(CAST(NEWID() as binary(6)) % 100000) + 1


http://www.jasoft.org/blog/CategoryView,category,Programaci%c3%b3n.aspx