不是NULL,我试了,IF RS=NULL THEN 不执行的,但是写 IF RS="" THEN 就可以了 SQL文select sum(case when charindex('988860',user_source)>0 then 1 else 0 end) as ACount, sum(case when charindex('816630',user_source)>0 then 1 else 0 end) as BCount, sum(case when charindex('816620',user_source)>0 then 1 else 0 end) as CCount from app_lt_user_info我查过的,有记录的(单独执行SQL文)
SQL文select sum(case when charindex('988860',user_source)>0 then 1 else 0 end) as ACount, sum(case when charindex('816630',user_source)>0 then 1 else 0 end) as BCount, sum(case when charindex('816620',user_source)>0 then 1 else 0 end) as CCount from app_lt_user_info我查过的,有记录的(单独执行SQL文)