insert into weiZhangCity_aliYunXiaoKa (provinceId,province) values (2,'上海市') SELECT @@IDENTITY as ID

<%

conn=Server.CreateObject("Adodb.Connection");
dbpath=Server.MapPath("image/#system#.mdb");
conn.ConnectionString="driver={Microsoft Access Driver (*.mdb)};dbq="+dbpath;
conn.open();
exec=Server.CreateObject("Adodb.Recordset");
exec2=Server.CreateObject("Adodb.Recordset");
filter="insert into users (name,companyName,email,country) values ('"+name+"','"+companyName+"','"+email+"','"+country+"')"
conn.execute(filter);
exec2 = conn.execute("SELECT @@IDENTITY as ID from users")// 获取刚刚插入记录的id
Session("userID")= parseInt(exec2("ID"));

%>