关于局部变量的问题
declare @a varchar(8000)


set @a = 'select case when (select sum(isnull(m7,0)) from count_for_ok where 用工类别 in


(select QZ from ZZQZLB) and 数据分类 in (select ZZ from ZZQZLB) and 年度 = 2007 and


dept_code in (select dept_code from deptcode where dept_code between 11601 and 11699)) =0 then 0 else (select sum(isnull(m7,0)) from count_for_ok where 用工类别 in (select QZ from

ZZQZLB) and 数据分类 in (select ZZ from ZZQZLB) and 年度 = 2007 and dept_code in
(select dept_code from deptcode where dept_code between 11601 and 11699)) '


select @a

为什么得到的结果，只显示


'select case when (select sum(isnull(m7,0)) from count_for_ok where 用工类别 in


(select QZ from ZZQZLB) and 数据分类 in (select ZZ from ZZQZLB) and 年度 = 2007 and


dept_code in (select dept_code from deptcode where dept_code between 11601 and 11699)) =0


后面一段却不见了？


我把这句分成两个char变量，然后select @a+@b 也不行。。。
请问是什么原因？
请问如何解决？

[解决办法]
select 的结果是根据 查询分析器,工具--选项--结果--每列最多字符数来显示的