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