declare @type varchar(10),@class varchar(10),@sql varchar(2000),@s int
set @type = '选择题'
set @class = '.net'
select @s = max(数目) from 表1 where 题型 = @class+@type
set @sql = 'select top '+@s+' * from 表2 where 类别 ='''+@class+''''
exec(@sql)
set @type = '选择题'
set @class = '.net'
select @s = max(数目) from 表1 where 题型 = @class+@type
set @sql = 'select top '+@s+' * from 表2 where 类别 ='''+@class+''''
exec(@sql)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货