用SQl Server2000创建
  create tagle #表名(或##表名)(name varchar(20),.....)
用Delphi 
function CreateTableInMemory(AFielDefs:TFieldDefs):TDataSet;
var
  TempTable:TClietDataSet;
begin
   TempTable:=nil;
   Result:=nil;
   if AFieldDefs<>nil then
   begin
     try
       TempTable:=TClientDataSet.create(application);
       TempTable.fieldDefs.Assign(AfieldDefs);
       TempTable.CreateDataSet;
       result:=TempTable as TdataSet;
     except
       if TempTable<>nil then
           TempTable.free;
       result:=nil;
       Raise;
    end;
  end;
end;