temporary table信息详情

temporary table发音

意思翻译

工作单元表

相似词语短语

temporary───adj.暂时的,临时的;n.临时工,临时雇员

temporary home───临时住所

temporary files───临时文件;暂存档;临时文件; 暂存档

temporary exhibition───临时展览

as temporary───暂时的

temporary accounts───[会计]临时性帐户;暂记帐户

temporary suspension───[计] 暂停,暂时挂起; 暂时罚出场

temporary housing───临时住房,应急住宅;临时住宿

temporary position───[计] 暂时位置

双语使用场景

Temporary table space can be either system or user.───临时表空间可以是系统的,也可以是用户的。

No user temporary table space was created.───没有创建用户临时表空间。

Listing 9 shows an example of a declared temporary table.───清单9展示了一个已声明临时表的示例。

Copy the BLOB to a temporary table or to a table variable , and then reassign the value to the original column .───请将BLOB复制到一个临时表或表变量,然后将值重新赋给原始列。

Also known as common table expression, this table is temporary table within the duration of a SQL statement.───也称为公用表表示,这种表是SQL语句执行期间存在的临时表。

At least one user temporary table space should be created to allow the definition of declared temporary tables.───至少应当创建一个用户临时表空间以允许定义已声明的临时表。

Prior to this release, the declared temporary table (DGTT) was the only type of user-defined temporary table.───在此发行版之前,已声明的临时表(DGTT)是唯一的一种用户定义的临时表。

Global temporary tables cannot be altered unless all users that have referenced the temporary table have disconnected.───除非已引用临时表的所有用户都断开了连接,否则无法变更全局临时表。

We recommend that you explicitly specify NULL or NOT NULL for each column in a temporary table.───建议对于临时表中的每列,显式指定NULL或NOTNULL。

英语使用场景

In DB2 LUW, a default system temporary table space called TEMPSPACE1 will be available for such DB2 DBM requirements as sorts or joins.

Use a created global temporary table (CGTT) for per-session storage of the baseline data (use one CGTT per table function).

Each row in the temporary table is comprised of a text (for example, "abcd-def ghi") and a word to search for (for example, "def").

For DB2 9.7, the limits on the size of large and temporary table spaces have been increased four-fold.

The key point to note here is that the procedure creates successfully even though the temporary table was not declared within the procedure body.

To demonstrate this use of the DELETE statement, create a temporary table, insert several rows, and delete them all, as shown in Listing 1.

Thus, a subquery can be thought of as a temporary table with statement scope.

The idea is, on a descriptive level, to build in the FROM clause a temporary table that consists of the data to be imported before calling any of the spatial functions.