SQL语句问题

[TheNextGates]

我写的存储过程运行时报错，但是SQL语句拿出来执行可以，找不到原因，代码如下：

create Proc Proc_getawardinfo  
@pagesize int,    
@currentpage int,  
@depname varchar(200)
as    
declare @sql varchar(max)    
set @sql='select awa_empid as 工号,emp_name as 姓名,awa_date as 奖励日期,awa_money as 奖励金额,emp_name as 批准人,Prm_name as 奖励方式, pri_name as 奖励类别,dep_name as 部门   
from awardemp inner join employee on awardemp.awa_empid=employee.emp_id   
inner join department on employee.emp_departid=department.dep_id   
inner join prizemethod on prizemethod.prm_id=awardemp.awa_modeid   
inner join prizetype on awardemp.awa_prizeid=prizetype.pri_id   
where dep_name='+@depname+' and awa_empid in(select top '+convert(varchar,@pagesize)+' awa_empid from awardemp where awa_empid in(select top '+convert(varchar,@pagesize)+' awa_empid from awardemp where awa_empid in(select top ' +convert(varchar,(@pagesize*@currentpage))+' awa_empid from awardemp order by awa_empid)order by awa_empid desc)order by awa_empid)'  

exec(@sql)

运行时：

exec Proc_getawardinfo 10,1,'采购部'
报错：列名'采购部'无效

采购部在表中是有值的。谁能帮我看下，拜托了！！！！

[baidu_24394755]

定义部分 varchar改成nvarchar试试看

[TheNextGates]

谢谢！解决了哈哈哈。