在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