一条语句实现asp批量更新数据库

sql用

conn.execute("update Product_Info set lastdate='"&now()&"' where id is not null")

access用
conn.execute("update Product_Info set lastdate=#"&now()&"#  where id is not null")