塬 塬上独狼 Unregistered / Unconfirmed GUEST, unregistred user! 2008-12-23 #1 假出我已select * from water1 where aa =ww; 怎样另存这个表呢?代码如何写;
李 李翔鹏 Unregistered / Unconfirmed GUEST, unregistred user! 2008-12-23 #2 select * into newtable from water1 where aa =ww;
0 007vivi Unregistered / Unconfirmed GUEST, unregistred user! 2008-12-23 #3 select into #table from water1 where aa=ww
T th_lmy Unregistered / Unconfirmed GUEST, unregistred user! 2008-12-23 #4 insert into newtable select * from water1 where aa=ww; 前提是两表结构必须一样
C chl720 Unregistered / Unconfirmed GUEST, unregistred user! 2008-12-23 #5 如果在程序端可以用 adoquery1.clone() adoquery1.open; adoquery2.clone(adoquery1) 這樣把adoquery1得到的數據集放到adoquery2中!
如果在程序端可以用 adoquery1.clone() adoquery1.open; adoquery2.clone(adoquery1) 這樣把adoquery1得到的數據集放到adoquery2中!
W weibinggui Unregistered / Unconfirmed GUEST, unregistred user! 2008-12-23 #6 SQL中建议用临时表技术，要是只是用他现在的数据，楼上不失为一种好方法，效率会比较高哦。
塬 塬上独狼 Unregistered / Unconfirmed GUEST, unregistred user! 2008-12-24 #7 各位我就是想把这个新的表另存一下为新的表，不是把数据存到一个已存在的表中呢
L luoyanqing119 Unregistered / Unconfirmed GUEST, unregistred user! 2008-12-24 #8 create table table2 as select * from table1 where aa =ww;
A andrew57 Unregistered / Unconfirmed GUEST, unregistred user! 2008-12-25 #10 select * into NewTableName from xxxx 追加insert into xxx (...) select (...) from yyyy
