问个数据库的问题,不知道难还是不难

asp中
if id="" then .Fields("id")=???
我想要id更新为null值不知道该如何写?
即id判断为空,如何在数据库更新为null值?

---------------------------------------------------------------

rs("id")=null '如果id是数字的话
rs("id")='' '如果id是字符的话
---------------------------------------------------------------

UPDATE test
SET id = NULL
WHERE (id = '')

Published At
Categories with Web编程
Tagged with
comments powered by Disqus