declare @aaa varchar(50); set @aaa=(select NumName from orderInfo where chaseOrderName='20110107046|5|880b841') if(@aaa=null or(len(@aaa)<8) or @aaa=' ') begin print '条件判断'; end查询出的 numName 为空,求我的if() 条件应该怎么写 才会打印 ‘条件判断’ 。在线等
set @aaa=(select NumName from orderInfo where chaseOrderName='20110107046|5|880b841')没有符合条件的值...
if(@aaa is null or (len(@aaa)<8) or @aaa=' ') 试试
if(@aaa is null or(len(@aaa)<8) or @aaa=' ')
declare @aaa varchar(50); set @aaa = ' ' set @aaa=(select NumName from orderInfo where chaseOrderName='20110107046|5|880b841') if(@aaa is null or @aaa=' ' or(len(@aaa)<8) ) begin print '条件判断'; end
试试
set @aaa = ' '
set @aaa=(select NumName from orderInfo where chaseOrderName='20110107046|5|880b841')
if(@aaa is null or @aaa=' ' or(len(@aaa)<8) )
begin
print '条件判断';
end