sql服务器中的数据库查询哪些记录含空值的语句   select * from ls where pt is null ,但不含空值的语句如何写？select * from ls where pt  no null ,为什么有错？请行家指教!

select * from ls where pt is not null
或者是
select * from ls where pt not is null