第一种:直接sql语句解决
conn.Execute "insert into tbl(a) values('aaa')"
' 此间保证 conn 没有 close() 没有再插入其它数据Set rs = conn.Execute("select @@identity as NewID"
第二种:
rs.addnew
rs("yhm")=yhm
rs("mm")=mm
rs("sfsh")="未审核"
rs("tjsj")=now
rs("hyjb_id")=hyjb_id
rs("sjh")=sjh
rs("xm")=xm
rs("xm")=xm
rs("yqm")=yqm
rs("sfzh")=sfzh
rs("scsfzzp")=scsfzzp
rs("sj_id")=sj_id
rs.update
newID=rs("id")
response.Write newID