哪要用什么样的方法取它的行数呢? 我这样写返回为0, 'select '+@FdName+'=identity(int,0,1),'+@FdShow+' into #tb from'+@QueryStr+@FdOrder+' a'+' select '+@@rowcount+' as '+@totalrow+' select'+@FdShow+' from #tb where '+@FdName+' between ' +@Id1+' and '+@Id2 能不能还有更好的办法,帮忙看看。谢谢!!!
我这样写返回为0,
'select '+@FdName+'=identity(int,0,1),'+@FdShow+'
into #tb from'+@QueryStr+@FdOrder+' a'+'
select '+@@rowcount+' as '+@totalrow+'
select'+@FdShow+' from #tb where '+@FdName+' between '
+@Id1+' and '+@Id2
能不能还有更好的办法,帮忙看看。谢谢!!!