select 1 from a where userid=1if @rowcount>0 print 1 else print 0
declare @I int set @I=100select case when T1.userid is null then 0 else 1 end from (select distinct userid from a) T1 right join (select @i as userid) T2 on T1.userid=T2.userid
简单点可以这样SELECT (CASE count(*) WHEN 0 then 0 ELSE 1 END) USERID FROM a WHERE USERID=100
或者这样 select isnull(sum(case when userid is null then 0 else 1 end),0) from a where userid=100
print 1
else
print 0
set @I=100select case when T1.userid is null then 0 else 1 end from
(select distinct userid from a) T1
right join (select @i as userid) T2 on T1.userid=T2.userid
FROM a WHERE USERID=100
select isnull(sum(case when userid is null then 0 else 1 end),0)
from a where userid=100
userid
2
select userid=isnull((select userid from 表 where userid=1),0)