随机抽奖存储过程[传参人数]

CREATE proc dbo.sp_GetDarwing
       @number int
AS
begin 
       declare @sql nvarchar(1000)
       set @sql='SELECT TOP  ' + cast(@number as nvarchar(50))+ ' *  FROM TblName order by newid()'
       exec(@sql)

end

@number 抽取的人数