ACCESS的方法:

set rs = server.createobject("adodb.recordset")
sql = "select * from news"
rs.addnew
rs("title") = "标题"
rs("content") = "内容"
rs.update
newid = rs("id")
rs.close
...

SQL SERVER的方法:

SQL SERVER用ACCESS的方法不行,必须在UPDATE后多加一句movelast

set rs = server.createobject("adodb.recordset")
sql = "select * from news"
rs.addnew
rs("title") = "标题"
rs("content") = "内容"
rs.update
rs.movelast
newid = rs("id")
rs.close
...