向两张表中添加数据的SQL语句

2024-12-12 18:44:21
推荐回答(3个)
回答1:

insert into tb1 (xxx) values(xxx);
insert into tb2 (xxx) values(xxx);

回答2:

create procedure p()
BEGIN
insert into 表A values();
insert into 表B values();
END

call p;

回答3:

Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from 表1,表2 "
rs.open sql,conn,1,3
rs(" 源")=列