【SQL】随机数中奖
--rand 随机数产生函数(抽奖)
delete #t_Team
create table #t_Team(
FNo int,
FName varchar(100)
)
insert into #t_Team
select 1,'宇坤'
Union
select 2,'婷莲'
Union
select 3,'顾军'
Union
select 4,'家辉'
Union
select 5,'家林'
Union
select 6,'智林'
Union
select 7,'华福'
Union
select 8,'文斌'
Union
select 0,'小明'
select FNo, '【'+FName + '】中奖了!' from #t_Team
where FNo in(select cast(floor(rand()*8) as int))