一、对null和空字符串的判断
1.对null 的判断:
--方法1:
select * from user where name is not null;
--方法2:
select * from user where ISNULL(name)=0
2.对空字符串的判断:
select * from user where LENGTH(trim(name))>0;
3.在函数或者存储过程中判断是否为null 或者 空字符串
SELECT id,name,
CASE
WHEN (ISNULL(NAME)=1) || (LENGTH(trim(NAME))=0) THEN 'aaa'
END
FROM
USER