with ADOQuery do
begin
Close;
SQL.Clear;
SQL.Add('Select c.CusName,Number');
SQL.Add('From #TempTable_t t Inner Join DB..Customer c');
SQL.Add('On t.cCusCode=c.cCusCode');
try
Open;
except;
Abort;
end;
end;
begin
Close;
SQL.Clear;
SQL.Add('Select c.CusName,Number');
SQL.Add('From #TempTable_t t Inner Join DB..Customer c');
SQL.Add('On t.cCusCode=c.cCusCode');
try
Open;
except;
Abort;
end;
end;
#,##开头的表,可以象用当前库中的表一样用,系统自动会连到tempdb上面去!