多谢指教,这样的确可以显示出来正确结果。 但是,要放入临时表c时应该怎么做呢? select RowA from a union select RowA from b into temp c 则提示“CURSOR not on SELECT statement”
SQL SERVER是这么写的(以后在这个贴除非说明都是SQL SERVER写法)select RowA into temp c from a union select RowA from b
哎哟,SQL SERVER 是这么写的:select RowA into #c from a union select RowA from b 或者:select RowA into c from a union select RowA from b
to Yang_(扬帆破浪)select RowA from a union select RowA from b into temp c 是正确的。我又试了一下,发现这句话在Delphi所写程序中或SQL Explorer中,会有出错提示“COURSOR not on SELECT statement”,在SQL Editor中却可得到正确结果,这应该是Delphi的问题,已经转向Delphi版,谢谢指教。
但是,要放入临时表c时应该怎么做呢?
select RowA from a
union
select RowA from b
into temp c
则提示“CURSOR not on SELECT statement”
into temp c
from a
union
select RowA from b
into #c
from a
union
select RowA from b
或者:select RowA
into c
from a
union
select RowA from b
union
select RowA from b
into temp c
是正确的。我又试了一下,发现这句话在Delphi所写程序中或SQL Explorer中,会有出错提示“COURSOR not on SELECT statement”,在SQL Editor中却可得到正确结果,这应该是Delphi的问题,已经转向Delphi版,谢谢指教。