set @sql='select a.rq,d.danwbh,d.dwmch,c.spbh,c.spmch,c.shpgg,c.shpchd,b.shl,c.dw,b.pihao,b.sxrq from jxdjhz a join ywmxk b on a.djbh=b.xgdjbh join spkfk c on b.spid=c.spid join mchk d on a.dwbh=d.dwbh'
set @sqlstring=' where a.rq>=convert(char(8),dateadd(month,-1,getdate()),120)+'26' and a.rq<=convert(char(8),dateadd(month,-1,getdate()),120)+'25' and c.shpchd like '%西安杨森制药有限公司%''
set @sqllast=@sql+@sqlstring
每个变量独立查看都没问题.
但是@sqllast的数值就被截断了
select @sqllast
------
'select a.rq,d.danwbh,d.dwmch,c.spbh,c.spmch,c.shpgg,c.shpchd,b.shl,c.dw,b.pihao,b.sxrq from jxdjhz a join ywmxk b on a.djbh=b.xgdjbh join spkfk c on b.spid=c.spid join mchk d on a.dwbh=d.dwbh where a.rq>=convert(char(8),dateadd(month,-1,getdate()),120)+'2'在这里被截断了!!
怎么回事呢?
