set 赋值问题

[usernamezero]

如下定义变量
--组合条件(盘点)
declare @ChaXunZuHe varchar(4000);
--组合条件出,入,调库
declare @ChuRuTiaoZuHe varchar(4000);
下边的赋值方法
set @ChaXunZuHe=(' select shijishuliang,CangKuBianHao,CangKu,BianHao,MingChen,GuiGe,SuoShuGongChang from ( '
+@FromTable+' )A'+' where 1=1 ')
--print @ChaXunZuHe;

--组合出,入,调库中的查询
set @ChuRuTiaoZuHe= (' select * from View_ImEx where 1=1 ')
--print @ChuRuTiaoZuHe;
if len(rtrim(@CaiLiaoBianHao))<>0
begin
--材料编号不为空 盘点组合条件
set @strCalLiaoBianHao=(' and BianHao='+''+''''+@CaiLiaoBianHao+'''');
--材料编号不为空 出入调库组合条件
set @strCRTCaiLiaoBianHao=(' and CaiLiaoBianHao='+''+''''+@CaiLiaoBianHao+'''');
set @ChaXunZuHe=(@ChaXunZuHe+@strCalLiaoBianHao);
set @ChuRuTiaoZuHe=(@ChuRuTiaoZuHe+@strCRTGongChangBianHao);
print 1
print @ChuRuTiaoZuHe
print 2
end

print @ChuRuTiaoZuHe 这时候打印为空的为什么 我的这个if 没有问题 此变量不为空我打印出来看了
而且pring @ChaXunZuHe 里边是有值的

[usernamezero]

print @ChuRuTiaoZuHe 这时候打印为空的为什么 我的这个if 没有问题 此变量不为空我打印出来看了
而且print @ChaXunZuHe 里边是有值的

[htl258_Tony]

declare @FromTable varchar(50)='tb',@CaiLiaoBianHao as varchar(30) ='abcde',
@strCalLiaoBianHao as varchar(800),@strCRTCaiLiaoBianHao as varchar(800)='',
@strCRTGongChangBianHao as varchar(800)=''
--组合条件(盘点)
declare @ChaXunZuHe varchar(4000);
--组合条件出,入,调库
declare @ChuRuTiaoZuHe varchar(4000);
--下边的赋值方法
set @ChaXunZuHe=(' select shijishuliang,CangKuBianHao,CangKu,BianHao,MingChen,GuiGe,SuoShuGongChang from ( '
+@FromTable+' )A'+' where 1=1 ')
print '1.'+@ChaXunZuHe; 

--组合出,入,调库中的查询
set @ChuRuTiaoZuHe= (' select * from View_ImEx where 1=1 ')
print '2.'+@ChuRuTiaoZuHe
if len(rtrim(@CaiLiaoBianHao))<>0 
begin
--材料编号不为空 盘点组合条件
set @strCalLiaoBianHao=(' and BianHao='+''+''''+@CaiLiaoBianHao+'''');
print '3.'+@strCalLiaoBianHao
--材料编号不为空 出入调库组合条件
set @strCRTCaiLiaoBianHao=(' and CaiLiaoBianHao='+''+''''+@CaiLiaoBianHao+'''');
print '4.'+@strCRTCaiLiaoBianHao
set @ChaXunZuHe=(@ChaXunZuHe+@strCalLiaoBianHao);
print '5.'+@ChaXunZuHe
set @ChuRuTiaoZuHe=(@ChuRuTiaoZuHe+@strCRTGongChangBianHao);
print '6.'+@ChuRuTiaoZuHe

end

/*
1. select shijishuliang,CangKuBianHao,CangKu,BianHao,MingChen,GuiGe,SuoShuGongChang from ( tb )A where 1=1 
2. select * from View_ImEx where 1=1 
3. and BianHao='abcde'
4. and CaiLiaoBianHao='abcde'
5. select shijishuliang,CangKuBianHao,CangKu,BianHao,MingChen,GuiGe,SuoShuGongChang from ( tb )A where 1=1  and BianHao='abcde'
6. select * from View_ImEx where 1=1 
*/

检查一下你哪个环节没有赋值.

[readfuture]

顶2楼。