Example Code:
<%
rs.MoveFirst
while not rs.EOF
rs("ColumnField")=rs("NewValue")+1
rs.moveNext
wend
%>
---------------------------------------------
<%
SQL= "select * from TB1 where ColumnField is null "
Set rs=GetSQLserverRecordset( conn, SQL)
%>
<%
if not rs.eof then
rs.MoveFirst
while not rs.EOF
rs("ColumnField")="new value"
rs.moveNext
wend
end if
rs.close
%>
------------------------------------------
注意 null 使用
是 select * from tb where f is null
不是 select * from tb where isnull(f)
是 is null 不是 isnull 也不是 =null
是 is not null 不是 is notnull
| 
