网站数据库由access转为mssql后，提示出错

Question

<%set rs=server.createobject("adodb.recordset")
if not isempty(request("ReViewID")) and IsNumeric(request("ReViewID")) then
sql="Select * From "& db_EC_Review_Table &" where ReViewID="& CheckStr(trim(request("ReViewID"))) &" Order by ReviewId DESC"
else
sql="Select * From "& db_EC_Review_Table &" where NewsId is NULL or NewsId < 1 Order by ReviewId DESC"
end if
rs.open sql,conn,1,1
提示上面部分出错，哪位老师给看一下，下面哪里出错了啊？

Answer 1

把NewsID is NULL 改为 Isnull(NewsID) 试试