D dingqiangqiang Unregistered / Unconfirmed GUEST, unregistred user! 2002-09-25 #1 我是一个delphi 的初学者, 那位高手能告诉我,如何在查询中,将所得到的查询结果存储到临时表中,又如何在程序中创建临时表呢
H hryyx Unregistered / Unconfirmed GUEST, unregistred user! 2002-09-25 #3 select * into #abc from Table1
S simonsin Unregistered / Unconfirmed GUEST, unregistred user! 2002-09-25 #4 select * into #aa from Table 这个带#的aa就是临时表。当你执行此语句时,程序会自动创建aa临时表,并把结果装进去。
P polo_han Unregistered / Unconfirmed GUEST, unregistred user! 2002-09-25 #5 with Query1 do Try Sql.Text := 'Create Table #temp (id Int Null, Name Char(20))' ; ExecSql ; Except End
with Query1 do Try Sql.Text := 'Create Table #temp (id Int Null, Name Char(20))' ; ExecSql ; Except End