SQL 语句问题(大家来帮帮忙呀)
表a
ID InPutdate
1 null
2 2005-1-1
inputdate 为日期类型
我根据Inputdate这个字段来检索 Inputdate为空的记录呢?
select * from a where inputedate =null
select * from a where inputedate = ' '我都试过了,都不行呢,大家有什么好办法吗?
小弟谢谢啦
------解决方案--------------------try select * from a where inputedate is null
------解决方案--------------------select * from a where inputedate is null
------解决方案--------------------inputedate is null
------解决方案--------------------is null
is not null