select * from KEHU where KHDM=‘D001’
select * from KEHU where (‘D001’+null) like ‘%D001%’
select * from KEHU where khdm in (‘D001’+null)
因为 加null整个都是null了这样语句就变成
select * from KEHU where null like ‘%D001%’
select * from KEHU where khdm in(null)
select * from KEHU where KHDM=‘D001’
select * from KEHU where (‘D001’+null) like ‘%D001%’
select * from KEHU where khdm in (‘D001’+null)
因为 加null整个都是null了这样语句就变成
select * from KEHU where null like ‘%D001%’
select * from KEHU where khdm in(null)