问 sql语句， 给分！ - MS-SQL Server / 基础类

如下！请看！

SQL code:

create procedure [dbo].[proc_TestPage]
@tablename nvarchar(255),--表名
@columns nvarchar(255),--要查询的列名
@sortcolumn nvarchar(255), --排序字段
@pagecount int, --每页记录数
@pageindex int, --页号
@wheres nvarchar(50),--条件
@counts int output
as
begin
[color=#FF0000]select @counts=count(ID) from @tablename where @wheres[/color]
declare @beginrow int
declare @endrow int
set @beginrow=0
set @endrow=0
set @beginrow=(@pageindex-1)*@pagecount+1
set @endrow=@pageindex*@pagecount
declare @sqlstr nvarchar(500)
set @sqlstr='with table1 as(select '+ @columns +',ROW_NUMBER() OVER(ORDER BY '+ @sortcolumn+' ) AS ROW'+ ' from '+@tablename+')'
if @wheres !=''
begin
set @sqlstr=@sqlstr +' SELECT * from TABLE1 WHERE '+@wheres+' and ROW BETWEEN '+cast(@beginrow as nvarchar )+' and '+cast(@endrow as nvarchar)
end
else
begin
set @sqlstr=@sqlstr +' SELECT * from TABLE1 WHERE ROW BETWEEN '+cast(@beginrow as nvarchar )+' and '+cast(@endrow as nvarchar)
end
exec(@sqlstr)
end


红色的那句话执行不了！
就是获取表中有多少条数据！
求解决方案！谢谢了！分而不是问题！

---

SQL code:
改成:
exec('select id fr