用vb代码，如何从sqlserver的a表查询出所需要的数据，并插入b表中？
比如：
a表
id,name,sex,age
将以上插入b表
b表
aid,aname,asex,aage
id=>aid,name=>aname,sex=>asex,age=>aage
问题点数：20、回复次数：6Top
1 楼hnlzh（吸海垂虹）回复于 2001-08-10 09:50:35 得分 10
INSERT INTO b表(aid,aname,asex,aage)select aid,aname,asex,aage from b表 where....
Top
2 楼xiaoboey（石块）回复于 2001-08-10 09:51:08 得分 5
dim rsA as adodb.recordset
dim rsB as Adodb.recordset
......
rsA.open "select * from a",.....
do while not rsA.eof
rsB.open "Select * from b where id="+cstr(bid),....
if rsB.eof then
rsB.addnew
rsb.fields(id).value=rsa.fields(aid).value
.......
rsb.update
end if
loopTop
3 楼Wesely（我就是我）回复于 2001-08-10 09:52:48 得分 0
用SQL ， Insert into ，就象hnlzh说的。Top
4 楼hnlzh（吸海垂虹）回复于 2001-08-10 09:58:10 得分 0
INSERT INTO b表(aid,aname,asex,aage)select id,name,sex,age from a表 where....Top
5 楼gujianxin（木头象）回复于 2001-08-10 10:30:19 得分 5
cnn.begintrans
err.clear
on error resumne next
cnn.execute("INSERT INTO B (aId,aName,aSex,aAge) select Id,Name,Sex,Age FROM A WHERE ..................")
if err then
cnn.rollbacktrans
else
cnn.committrans
end ifTop
6 楼acev（睡眠不足(域名 .com ￥55，.cn ￥30 QQ:230567)）回复于 2001-08-10 10:36:12 得分 0
("INSERT INTO B (aId,aName,aSex,aAge) select Id,Name,Sex,Age FROM A WHERE ..................")
这个命令，在sqlserver能执行么？我不太明白。Top
