SQL 语句问题(大家来帮帮忙呀)表aIDInPutdate1null22005-1-1inputdate为日期类型我根据Inputdate这个字段
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
