asp+sqlserver

SQL = "insert into NSW_Wt(bt,nr,dalei,xsf,userid,twtime,flag)values('"&request("bt")&"','"&request("nr")&"','"&request("classid")&"','"&request("xsf")&"','"&Newasp.memberid&"','"&now()&"',1)  select   NEWID=@@IDENTITY"
       set   rs=conn.Execute(sql)  
       set   rs=rs.nextrecordset 
      id=rs(0)

asp+access

rs.open "table",cnstring,1,2,&H0002

rs.addnew

rs("date") = now

rs.update

id = rs("id")

rs.close