各位高手看看下面存储过程里面的@str写得有什么问题?

Question

            declare @str varchar(120)            set @str= 'insert into #Tmp(ID,Time,Analys,Flag) select top ' + cast(@RecordCount as varchar) + ' ID,Time,Analys,Flag FROM t_sample1 WHERE ShiftID='KK' and NameID='+@NameID+' ORDER BY Time DESC'            exec (@str)

Answer 1

120太小，改为2000试试