if exists(SELECT 1 FROM aa WHERE id = '101') print '1' else print '0'
SELECT CASE WHEN userid IS NULL THEN '0' ELSE '1' END AS aa FROM aa WHERE (id = '101') --- lz在where中已经限定了范围,上边判断的范围当然都是id='101'的情况了:)
SELECT CASE userid WHEN NULL THEN '0' ELSE '1' END AS aa FROM aa WHERE (id = '101')试试
marco08(天道酬勤)----------- 能不能有个as 让我能得到值??
--這樣?create table aa(userid varchar(10)) insert aa select '102'select aa=case when (select userid from aa where userid='101') is null then '0' else '1' end--result aa ---- 0(1 row(s) affected)
SELECT Case When Max(userid) IS NULL THEN '0' ELSE '1' END AS aa FROM aa WHERE id = '101'
print '1'
else
print '0'
FROM aa
WHERE (id = '101')
---
lz在where中已经限定了范围,上边判断的范围当然都是id='101'的情况了:)
FROM aa
WHERE (id = '101')试试
能不能有个as 让我能得到值??
insert aa select '102'select aa=case when (select userid from aa where userid='101') is null then '0' else '1' end--result
aa
----
0(1 row(s) affected)
FROM aa
WHERE id = '101'