declare @sql varchar(1000) declare @degreename varchar(100) create table #Temp2(QuesID bigint,QuesTitle varchar(2000)) set @degreename='''高难度''' set @sql='insert into #Temp2 select top '+@HighDegreeNum+' QuesID, QuesTitle from exam_tQuestion where degreename='+@degreename+' and SortID='+@PaperSortID+' and QuesType= '''+@QuesType+''' order by newid() ' exec(@sql)
--tryuse pubs godeclare @top int set @top=5 exec('select top '+@top+' * from titles')
declare @degreename varchar(100)
create table #Temp2(QuesID bigint,QuesTitle varchar(2000))
set @degreename='''高难度'''
set @sql='insert into #Temp2 select top '+@HighDegreeNum+' QuesID, QuesTitle from exam_tQuestion where degreename='+@degreename+' and SortID='+@PaperSortID+' and QuesType= '''+@QuesType+''' order by newid() '
exec(@sql)
godeclare @top int
set @top=5
exec('select top '+@top+' * from titles')