帮我检查一下SQL语句的错误吧，谢谢

[am2002cnfj]

下列的SQL调试时候没有信息输出，但如果把“+ ''' And((@intClassesID IS NULL OR @intClassesID=0) OR studentsClassesID=' + Cast(@intClassesID as varchar(5))+ '))'”注释掉，就OK了，请请教！

create table #t(姓名 varchar(40),item varchar(20),次数 int, 结论 varchar(40),studentsID int,studentsSex varchar(2),studentsClassesID int)
insert into #t
select t2.studentsName,t1.exItem,t1.exTime,t1.exConclusion,t2.studentsID,t2.studentsSex,t2.studentsClassesID
from studentsExaminationManagement t1,informationStudent t2
where exItem=1 and t1.studentID=t2.studentsID

declare @s varchar(1000)
declare @chvItem varchar(2)
declare @intClassesID int
set @chvItem='1'
set @s='select studentsClassesID,studentsID,姓名'
select @s=@s+', max( case when 次数='''+rtrim(次数)+''' then 结论 else '''' end) as 次数'+rtrim(次数)
from (select distinct 次数 from #t) a
set @s=@s+' from #t where item='''+ @chvItem
+ ''' And((@intClassesID IS NULL OR @intClassesID=0) OR studentsClassesID=' + Cast(@intClassesID as varchar(5))+ '))'
+ ''' group by studentsClassesID,studentsID,姓名 order by studentsClassesID,studentsID'

[raoman]

@intClassesID 没有被赋值，Cast(@intClassesID as varchar(5)) 也就是null了，导致连接运算的结果也为空了

[昵称被占用了]

没贴全

[昵称被占用了]

变量@intClassesID 是在外面定义的
在exec语句中没有定义

可以用sp_executesql存储过程

[昵称被占用了]

参考下：
http://community.csdn.net/Expert/topic/5614/5614438.xml?temp=.1441461

[hellowork]

改为:
set @s=@s+' from #t where item='''+ @chvItem
+ ''' And((ISNULL(studentsClassesID,0) = 0 OR studentsClassesID=' + RTRIM(@intClassesID) + '))'
+ ''' group by studentsClassesID,studentsID,姓名 order by studentsClassesID,studentsID'

[hellowork]

抱歉,更正一下:
set @s=@s+' from #t where item='''+ @chvItem
+ ''' And((ISNULL(studentsClassesID,0) = 0 OR studentsClassesID=' + RTRIM(@intClassesID) + '))'
+ ' group by studentsClassesID,studentsID,姓名 order by studentsClassesID,studentsID'