SQL语句中把某个字段是否为NULL作为查询条件

[luzongxuan]

SQL语句中把某个字段是否为NULL作为查询条件，具体的SQL语句怎么写？
注：我用的MS SQL SERVER2008。

[波导终结者]

where xx is null

[橙宝宝]

select * from 数据库名 where NAME is null
显示所有姓名为空的记录

[duxj007]

select * from 表 where 列名 is null

[wuyq11]

select * from 表 where 列 is null

[link_biao]

select AAA from BBB where CCC is null

[jekeywood]

select * from table where field is null
or 
select * from table where file is not null