随机取数代码
从数字1-15这15个数中随机取一个数作为@k的值的sql代码是？
请教！
[解决办法]
declare @k int
declare @tab table (RndNum int)
declare @i int
set @i = 1
while @i < 15
begin
insert into @tab(RndNum) select @i
set @i = @i + 1
end
set @k = (select top 1 RndNum from @tab order by newid())
print @k
