在ASP中判断SQL语句是否执行成功

利用err对象:

sql="insert into table(f1,f2) values('v1','v2')"
conn.execute sql
if err.number<>0 then
response.write "出错了："& err.description err.clear
else
response.write "OK"
end if