下面语句有没有select+insert的组合写法
set rs=server.CreateObject("adodb.recordset")
strSql="select userid from a"
rs.open strSql,conn
do while not rs.eof
strSql1 = "insert into b(userid) values(" &rs(0) & ")"
conn.execute(strSql1)
rs.movenext
loop
rs.close
參考答案:拷贝表(拷贝数据,源表名:a 目标表名:b) (Access可用)
insert into b(userid) select userid from a