Crea numeros aleatorios MSqlServer

Random.sql

------------------------
-- by Jsn
-- jason.scz@gmail.com
------------------------

go
create view vwRANB
as
select CAST(ROUND(RAND(),0) AS BIT) as Bln

go
create view vwRAND
as
select RAND() as Rnd

go
create function fnRAND(@min int,@max int)returns int
as
begin
	declare @rnd as int
	while @rnd<@min or @rnd>@max or @rnd is null
	begin
		if len(@max)>len(@min)
			set @rnd = (select round(rnd*(power(10,len(@max))),0) from vwRAND)
		else
			set @rnd = (select round(rnd*(power(10,len(@min))),0) from vwRAND)
		
		if @min < 0 or @max < 0
		begin
			declare @flag as int
			set @flag = (select Bln from vwRANB)
			if @flag>0
				set @rnd = @rnd*-1
		end
	end
	return @rnd
end
go

select dbo.fnRAND(0,2000)
select dbo.fnRAND(0,2)
select dbo.fnRAND(-55,7)
select dbo.fnRAND(-99,99)