还是exec sp_executesql的问题
declare @kcgs int, @classid int
set @sql=N'select top 1 @kcgs=kc'+RTrim(convert(varchar, @nTemp))+' from V_库存_分库 where classid='+RTrim(convert(varchar, @classid))+' order by id desc'
exec sp_executesql @sql,N'@kcgs int', @kcgs
为什么得不到@kcgs的值,,,值赋不进去