SQl 语句生成一定范围的随机数小数咋写？
如生成0.321到0.345之间的数.
[解决办法]
DECLARE @n DECIMAL(4,3)
WHILE 1=1
begin
SELECT @n=FLOOR(RAND()*1000)/1000
IF @n BETWEEN 0.321 AND 0.345
break
END
SELECT @n