temporary table 中文意思是什麼

temporary table 解釋
工作單元表
  • temporary : adj 1 一時的，暫時的，臨時的 （opp lasting）。2 曇花一現的，無常的 （opp permanent）。n 臨時工 （...
  • table : n 1 桌子；飯桌，餐臺。2 手術臺；工作臺；游戲臺；賭臺；寫字臺。3 （飯桌上的）食物，酒菜，伙食；一...
  1. Intent locks, row locks, and page locks all count toward the escalation count, unless they are temporary table locks

    除非屬于臨時表鎖，否則意向鎖、行鎖和頁鎖都將計入升級統計中。
  2. Using a procedure to initialize the temporary table yields three key benefits

    使用過程來初始化臨時表可帶來三個主要優點：
  3. The procedure developer does not have to hunt through application code which may be maintained by another person to find the ddl of the temporary table

    過程開發人員不必為了得到臨時表的ddl而找遍應用程序代碼（可能是由其他人來維護的） 。
  4. The derived table in mysql is something similar to db2 express temporary table

    Mysql中的派生表有點類似於db2 express臨時表
  5. The flexibility of having a declared object no dba cares what the app does as long as user temporary table space is readily available comes with a downside : for a statement to be compiled, the object must exist

    具有聲明對象的靈活性（只要用戶臨時表空間是立即可用的， dba就不會再關心該應用程序在做什麼）也帶來了一個不足：對于要進行編譯的語句來說，這個對象必須存在。
  6. How can p2 and p3 reference a temporary table declared in p1 without re - declaring it themselves

    P2和p3又如何能引用p1中聲明的臨時表而無需再重新聲明呢？
  7. In both cases, attempts to re - declare a temporary table within the same session will result in the following error

    這兩種情況下，若在相同會話中企圖重新聲明臨時表將導致如下錯誤：
  8. Since db2 version 7. 2, db2 udb has supported storing data in non - persistent, in - memory, session - specific tables formally known as declared global temporary tables hereafter referred to as temporary tables. this article will not dwell on the many different ways that a temporary table can be defined or used such topics are already covered in the

    自db2 v7 . 2以來， db2 udb已經支持在駐留內存、非持久性、特定於會話的表中存儲數據，這些表的正式名稱為已聲明的全局臨時表（以下簡稱為臨時表） 。
  9. Inserts data into a temporary table. bulk insert task

    大容量插入任務將數據插入到臨時表。
  10. An application wants to declare temporary table t, populate it, and then call procedure p to process the data

    一個應用程序需要聲明臨時表t ，填充它后並調用過程p來處理數據。
  11. The method for estimating the size of a temporary table size is the same as estimating the size of a standard table

    估計臨時表大小的方法與估計標準表大小的方法相同。
  12. So, for reasons of encapsulation, the procedure declares its on temporary table and then drops it when the temp is no longer needed

    因此，為了進行封裝，該過程聲明dgtt位於臨時表上，然後，當不再需要這個臨時表時，可以刪除它。
  13. Declared global temporary table support was significantly enhanced for db2 udb version 8. 1

    對已聲明的全局臨時表的支持在db2 udb v8 . 1中得到了顯著的加強。
  14. Such as creating a global temporary table

    中的系統或維護任務，如創建一個全局臨時表。
  15. A. using bcp to bulk export from a global temporary table

    使用bcp從臨時表大容量導出數據
  16. Global temporary table for example,

    對于全局臨時表，可以使用
  17. Utility to bulk export data in character format from the global temporary table

    中字元格式的數據大容量導出到
  18. The key point to note here is that the procedure creates successfully even though the temporary table was not declared within the procedure body

    這里要注意的關鍵是，即使在過程體中沒有聲明臨時表，該過程也被成功創建。
  19. Local temporary table for example,

    若要向本地臨時表（例如，
  20. Online cannot be set to on when an index is being created on a local temporary table

    對本地臨時表創建索引時， online不能設置為on 。
分享友人
分享到 Line

分享到臉書