select convert(decimal(18,2),rand()), convert(decimal(18,2),rand()) select newid() SELECT substring(LTrim(abs(checksum(newid()))),0,5) update tablename
set FA=100,
FB=ROUND(RAND(substring(LTrim(abs(checksum(newid()))),0,6)) * 50, 0),
FC=ROUND(RAND(substring(LTrim(abs(checksum(newid()))),0,6)) * 50, 0)