SQL取随机值问题

[wdxgdiy]

要求从1000至 99999之间取一个随机值 但是不包含数据库中某列的值

数据库表T结构（值为用户添加的 不断增加的）
VALUE
22
33
432
5


也就是说这个随机数不能包含 这一列的值 请问这个要怎样编写语句

[feilniu]

WITH T AS(SELECT v = 22 UNION ALL SELECT 33 UNION ALL SELECT 1432 UNION ALL SELECT 1005)
SELECT TOP(1) n.n
FROM dbo.Nums n
WHERE n.n BETWEEN 1000 AND 99999
	AND NOT EXISTS (SELECT * FROM T WHERE T.v = n.n)
ORDER BY NEWID()

[fpzgm]

select cast( floor(rand()*100000) as int)
except
select cast( floor(rand()*1000) as int)
except
select value from t

[oO寒枫Oo]

create table T (value int)
insert into T  values(22)
insert into T  values(33)
insert into T  values(432)
insert into T  values(5)


select cast((rand()*(99999-1000)+1000) as int)
except
select cast(value as int) from t

[中国风]

DECLARE @i INT
SET @i=ABS(CHECKSUM(NEWID()))%99000+1000
WHILE EXISTS(SELECT 1 FROM Table1 WHERE VALUE=@i)
	SET @i=ABS(CHECKSUM(NEWID()))%99000+1000
SELECT @i