超长字符串问题,急!
我把长的字符串放到临时表里
用的时候把每一行都加起来,不知道怎么做
出类事:exec(@sql1+@sql2)
select case when(grouping(IsCheckIn) = 1) then '汇总' else case when (IsCheckIn=1) then '已检' else '未检' end end as IsCheckIn, '0到6' As AgeLevel, count(*) As Count from tbPerson,tbMedical where tbPerson.PersonId = tbMedical.PersonId and tbPerson.Code Like '00
Union All select case when(grouping(IsCheckIn) = 1) then '汇总' else case when (IsCheckIn=1) then '已检' else '未检' end end as IsCheckIn, '7到12' As AgeLevel, count(*) As Count from tbPerson,tbMedical where tbPerson.PersonId = tbMedical.PersonId and tbPerson.
Union All select case when(grouping(IsCheckIn) = 1) then '汇总' else case when (IsCheckIn=1) then '已检' else '未检' end end as IsCheckIn, '13到18' As AgeLevel, count(*) As Count from tbPerson,tbMedical where tbPerson.PersonId = tbMedical.PersonId and tbPerson
Union All select case when(grouping(IsCheckIn) = 1) then '汇总' else case when (IsCheckIn=1) then '已检' else '未检' end end as IsCheckIn, '19到24' As AgeLevel, count(*) As Count from tbPerson,tbMedical where tbPerson.PersonId = tbMedical.PersonId and tbPerson
Union All select case when(grouping(IsCheckIn) = 1) then '汇总' else case when (IsCheckIn=1) then '已检' else '未检' end end as IsCheckIn, '25到30' As AgeLevel, count(*) As Count from tbPerson,tbMedical where tbPerson.PersonId = tbMedical.PersonId and tbPerson
Union All select case when(grouping(IsCheckIn) = 1) then '汇总' else case when (IsCheckIn=1) then '已检' else '未检' end end as IsCheckIn, '31到36' As AgeLevel, count(*) As Count from tbPerson,tbMedical where tbPerson.PersonId = tbMedical.PersonId and tbPerson
Union All select case when(grouping(IsCheckIn) = 1) then '汇总' else case when (IsCheckIn=1) then '已检' else '未检' end end as IsCheckIn, '37到42' As AgeLevel, count(*) As Count from tbPerson,tbMedical where tbPerson.PersonId = tbMedical.PersonId and tbPerson
Union All select case when(grouping(IsCheckIn) = 1) then '汇总' else case when (IsCheckIn=1) then '已检' else '未检' end end as IsCheckIn, '43到48' As AgeLevel, count(*) As Count from tbPerson,tbMedical where tbPerson.PersonId = tbMedical.PersonId and tbPerson
Union All select case when(grouping(IsCheckIn) = 1) then '汇总' else case when (IsCheckIn=1) then '已检' else '未检' end end as IsCheckIn, '49到54' As AgeLevel, count(*) As Count from tbPerson,tbMedical where tbPerson.PersonId = tbMedical.PersonId and tbPerson
Union All select case when(grouping(IsCheckIn) = 1) then '汇总' else case when (IsCheckIn=1) then '已检' else '未检' end end as IsCheckIn, '55到60' As AgeLevel, count(*) As Count from tbPerson,tbMedical where tbPerson.PersonId = tbMedical.PersonId and tbPerson
Union All select case when(grouping(IsCheckIn) = 1) then '汇总' else case when (IsCheckIn=1) then '已检' else '未检' end end as IsCheckIn, '大于60' As AgeLevel, count(*) As Count from tbPerson,tbMedical where tbPerson.PersonId = tbMedical.PersonId and tbPerson.C
/*
以上是我的sql union后的结果
*/
但是我怎么运行它?
declare @sss nvarchar(4000)
set @sss='select ''''+a from #t'
exec @sss
但是报错:
服务器: 消息 2812,级别 16,状态 62,行 94
未能找到存储过程 'select ''+a from #t'。