SQL Server查询null值

 select News_Status,* from dbo.web_office a left join  web_news b  
 on a.office_id = b.News_Office_ID 
 and News_Model_id = '0105' 
 and News_Status <>'X'  
 where office_ishide =0 

第一种方式在关联条件里加判断，查询结果如下：

 select News_Status,* from dbo.web_office a left join  web_news b  
 on a.office_id = b.News_Office_ID 
 and News_Model_id = '0105' 
 where office_ishide =0 and isnull(News_Status,'') <>'X'

第二张方法是给null一个空值，查询结果如下：