28,391
社区成员
发帖
与我相关
我的任务
分享
<!--#include file="conn.asp"-->
<%
'对于A表
name1=request("name1")
set rs=server.createobject("adodb.recordset")
sql="select top 1 * from a "
rs.open sql,conn,3,3
rs.addnew()
rs("name")=name1
rs.update
'这里得到a_id
a_id=rs("id")
rs.close
set rs=nothing
'
对于B表
set rs=server.createobject("adodb.recordset")
sql="select top 1 * from b "
rs.open sql,conn,3,3
rs.addnew()
rs("a_id")=a_id
rs("score")=score 'score根据你实际来源
rs.update
rs.close
set rs=nothing
%>
Dim SQL
SQL = "INSERT ta(name) values('aaa');"
SQL = SQL & "INSERT tb(a_id,score) VALUES(SCOPE_IDENTITY()," & score的asp变量 & ")"
Conn.Execute(SQL)
Dim SQL
SQL = "INSERT ta(name) SELECT 'aaa';"
SQL = SQL & "INSERT tb(a_id,score) SELECT SCOPE_IDENTITY()," & score的asp变量
Conn.Execute(SQL)
INSERT ta (name) SELECT 'name的值'
INSERT tb SELECT SCOPE_IDENTITY(),score的值