T talk_me Unregistered / Unconfirmed GUEST, unregistred user! 2001-10-19 #1 如table1 为 aa bb cc 111 222 333 转为aa 111 bb 222 cc 333
E eric.youbin Unregistered / Unconfirmed GUEST, unregistred user! 2001-10-19 #2 不一定要对数据库进行修改吧? 你可以在显示上做点处理就可以了!
S sunglow28 Unregistered / Unconfirmed GUEST, unregistred user! 2001-10-19 #6 使用STRINGGRID控件代替DBGRID.
T tseug Unregistered / Unconfirmed GUEST, unregistred user! 2001-10-19 #7 可以的, 但前提是aa bb cc类型一样 (select aa from table1) union (select bb from table1) union (select cc from table1)
可以的, 但前提是aa bb cc类型一样 (select aa from table1) union (select bb from table1) union (select cc from table1)
H htw Unregistered / Unconfirmed GUEST, unregistred user! 2001-10-23 #13 写代码, 将一个表读入到一个二维数组 再按你要的位置, 重新写入表不就行了
T talk_me Unregistered / Unconfirmed GUEST, unregistred user! 2001-11-02 #14 对不起,但不行 (select aa from table1) union (select bb from table1) union (select cc from table1) 是交集,非也, 各位在发表一下高见
对不起,但不行 (select aa from table1) union (select bb from table1) union (select cc from table1) 是交集,非也, 各位在发表一下高见
T tseug Unregistered / Unconfirmed GUEST, unregistred user! 2001-11-02 #15 >select aa from table1) union (select bb from table1) union (select cc from table1) >是交集,非也, 是并集呀, 我用过可以的.
>select aa from table1) union (select bb from table1) union (select cc from table1) >是交集,非也, 是并集呀, 我用过可以的.
B Brave Unregistered / Unconfirmed GUEST, unregistred user! 2001-11-02 #16 存储过程建立临时表,并写入数据,储存过程返回临时表数据集的游标
T talk_me Unregistered / Unconfirmed GUEST, unregistred user! 2001-11-02 #17 我想你理解错了,我要的是将aa bb转换为 aa bb 而不是表a为aa,表b为bb,得到aa bb 不过谢谢你
T talk_me Unregistered / Unconfirmed GUEST, unregistred user! 2001-11-05 #19 谢谢yntw我就是这么做的,先select 在弄到临时表中,不过我想有没有简单的办法