数据库随机查询

create table aa(id int identity,name varchar(20))
insert into aa select '读书'
insert into aa select '绘画'
insert into aa select '音乐'
insert into aa select '古董'
insert into aa select '名作'
insert into aa select '钱币'
insert into aa select '邮票'
insert into aa select '旅游'
insert into aa select '探险'
insert into aa select '自驾游'
insert into aa select '摄影'
insert into aa select '游泳'
insert into aa select '高尔夫'
insert into aa select '健身'
insert into aa select '运动'
insert into aa select '水上运动'

declare @name varchar(50),@i int,@sql nvarchar(1000)
set @i=round(2+rand(),0)
set @sql='
set @n=''''
select @n=@n+name+'','' from  (select top '+ltrim(@i)+' name from aa
order by newid())
go
set @n=left(@n,len(@n)-1)
'
declare @v varchar(1000)
exec sp_executesql @sql ,N'@n varchar(1000) output ' ,@v output
select  @v