在SQLServer 2000中,使用SQL语句判断某一字段为空,用以下语句:
SELECT *
FROM XkzsQsID
WHERE (YouXRQ < GETDATE()) AND (IsLogout IS NULL)
使用SQL语句判断某一字段不为空,用以下语句:
SELECT *
FROM XkzsQsID
WHERE (YouXRQ < GETDATE()) AND (NOT IsLogout IS NULL)
SELECT *
FROM XkzsQsID
WHERE (YouXRQ < GETDATE()) AND (IsLogout IS NULL)
使用SQL语句判断某一字段不为空,用以下语句:
SELECT *
FROM XkzsQsID
WHERE (YouXRQ < GETDATE()) AND (NOT IsLogout IS NULL)