比如现在有两个表table1和table2，，我想将table1里的一整条数据复制到table2里，如果用ASP是要怎么实现啊，而且是批量的复制啊，还请个高手教教我这小弟啊~~~
---------------------------------------------------------------
insertbak=" insert into table2 select * from table1 "
cnn.execute(insertbak)
---------------------------------------------------------------
首先要保证表table1和table2的结构完全一样。
sql="insert into table2 vlaues(select * from table1)"
conn.execute (sql)
---------------------------------------------------------------
sql="insert into table2(a1,a2,a3) select a1,a2,a3 from table1"
conn.execute(sql)
---------------------------------------------------------------
table1和table2的结构要完全一样
conn.execute "insert into table2 vlaues(select * from table1)"
---------------------------------------------------------------
sql="insert into table2 vlaues(select * from table1)"
conn.execute (sql)
---------------------------------------------------------------
sql="insert into table2(a1,a2,a3) select a1,a2,a3 from table1"
conn.execute(sql)
——————————————————————————————————
www.91asp.cn
有时间到这里找资料找书籍，你会发现asp以及.net很容易！
前提是你努力学习！