sql 2005 存储过程中给变量赋值出错

Question

-- =============================================
ALTER PROCEDURE [dbo].procselect,
@index int,---当前页码
@size int,---每页记录数
@n INT OUTPUT,
@pages int output---总页数，输出参数
)
AS
BEGIN

SET NOCOUNT ON;

declare @strc varchar(50);
declare @num int;----商品表的总记录数
-- set @type = @title;
select @num=count(*) from Error a where a.Tname=@name;-----商品表的总记录数
select @N=@num;
----计算总页数
if(@num=0)
set @pages=0;

else
begin
if(@num%@size=0)
   set @pages=@num/@size;

 else
   set @pages=@num/@size + 1;
declare @i int,@j int;

set @i=(@index-1)*@size+1;---当前页起始记录编号
set @j=@index*@size;----当前页最大记录编号

exec('select * from
( select row_number() over (order by errID)as IndexNum,

• from Error where Tname='+@name+' )a where a.IndexNum>='+@i+' and a.IndexNum<='+@j

)
end
END

消息 207，级别 16，状态 1，第 2 行
列名 'hsj' 无效。

Answer 1

 exec('select * from 
( select row_number() over (order by errID)as IndexNum,
from Error where Tname='+@name+' )a where a.IndexNum>='+@i+' and a.IndexNum<='+@j
)
语句改成如下
exec('select * from 
( select row_number() over (order by errID)as IndexNum
from Error where Tname='''+@name+''' )a where a.IndexNum>='+@i+' and a.IndexNum<='+@j
)