• Due to the large amount of data in the audit log table, a single INSERT statement will usually fail because the data per transaction exceeds the log file size of the database system.

    因为审核日志表格里有大量的数据,单独的insert语句通常会失败,这是因为每个事务的数据超过了数据库系统里的日志文件的容量。

    youdao

  • INSERT adds the input data to the table without changing any existing data.

    INSERT将输入数据添加到表中,并且不更改任何现有数据。

    youdao

  • Note: Alternatively you can create a database trigger to capture every INSERT on your table and tell it to validate the data as XML using the XMLVALIDATE function before performing the INSERT.

    注意:您也可以选择创建一个数据库触发器来捕捉表上的每个INSERT操作,并告诉它在执行INSERT之前使用XMLVALIDATE函数验证XML数据。

    youdao

  • INSERT mode adds the input data to the table without changing any existing data.

    INSERT模式添加输入数据到表中,并且不会更改任何现有数据。

    youdao

  • The DB2 transaction associated with an upload included generating a unique document ID, logging the upload in the activity history table, and executing a SQL INSERT into 18 tables.

    与上传相关联的DB2事务包括生成惟一的文档id、在活动历史表中记录这次上传以及对18个表执行SQLINSERT。

    youdao

  • The INSERT INTO works similarly to SQL, but again, this is URI-based rather than string-, table-, and name-based, which allows the operation to be done across HTTP.

    INSERT INTO 的工作原理类似于SQL,但是同样,这是基于URI 的,而非基于字符串、基于表和基于名称的,这允许使用 HTTP 完成操作。

    youdao

  • To illustrate the new DB2 9.5 XML update functionality, the sample table and data defined by the following CREATE TABLE and INSERT statements are used.

    为了解释新的DB2 9.5XML更新功能,我们使用下面的CREATETABLE和INSERT语句定义示例表和数据。

    youdao

  • Performing a SELECT statement on the table fetches the messages in the queue, and and doing an INSERT statement on the table sends the message.

    在表上执行一条select语句就可以取得队列中的消息,而执行表上的insert语句就可以发送消息。

    youdao

  • Since there is no COMMIT between the INSERT and SELECT statement, potentially the deadlock is caused by a table scan.

    由于INSERT和select语句之间没有COMMIT,死锁可能是由表扫描引起的。

    youdao

  • FREEPAGE should be used if your table rows are larger than half a page, since you cannot INSERT a second row on a page in such circumstances.

    如果表行大于页宽的一半,则应该使用FREEPAGE,因为在那样的环境下不能在一页上再INSERT一行。

    youdao

  • You can see from the form of the INSERT INTO in Listing 5 that a table had been created to correspond with the element in our DTD.

    可以从清单5中INSERT INTO的形式看出,对应dtd中的元素创建了一个表。

    youdao

  • Use Load and a staging table or a multithreaded application to achieve Insert parallelism.

    使用Load和staging表或多线程应用程序,以实现Insert的并行性。

    youdao

  • Add data to the table using SQL INSERT statements.

    使用SQLinsert语句将数据添加到表中。

    youdao

  • To load data from the data file /data/americascust.dat (created above) into the base table customer, use the INSERT statement as follows

    要将数据文件 /data/americascust.dat(此前已创建)中的数据加载到基表customer,可以使用INSERT 语句(如下所示)

    youdao

  • If you have modified the Users table schema, be sure to make the matching changes to the Insert statement.

    如果已经修改了users表的模式,那么一定要对insert语句进行相应的修改。

    youdao

  • The DBMS ensures that the index is always consistent with the data in the table by updating it during INSERT, UPDATE, and DELETE operations.

    通过使用INSERT、UPDATE和DELETE操作对索引进行更新,DBMS能够确保索引始终与表数据一致。

    youdao

  • You can now define multiple INSERT, DELETE, UPDATE, and SELECT triggers on a table and multiple INSTEAD OF triggers for the view.

    现在可以在一个表上定义多个INSERT、DELETE、UPDATE和SELECT触发器,也可以在一个视图上定义多个INSTEADOF 触发器。

    youdao

  • When DB2 encounters an INSERT on an MDC table, it looks for a free block.

    当DB 2碰到对mdc表的INSERT操作时,它寻找一个空闲的块。

    youdao

  • This example moves the same CUSTOMER_INFO table, but it USES the LOAD option instead of the INSERT FROM CURSOR option, which is the default.

    该示例移动同一个customer_info表,但是使用了LOAD选项,而不是INSERTFROM CURSOR选项,后者是默认配置。

    youdao

  • In the sample code, we have created three Triggers on the customer table for Insert, Update, and Delete.

    在示例代码中,我们在customer表上创建了三个触发器,分别用于Insert、Update和Delete操作。

    youdao

  • In Oracle 10g, if there is a BEFORE INSERT TRIGGER and a NOT NULL constraint on a table, then the BEFORE TRIGGER is executed first, and then the constraint check is performed.

    在Oracle10g中,如果表上同时存在BEFORE INSERT触发器和NOT NULL约束,那么先执行BEFORE触发器,然后执行约束检查。

    youdao

  • When a specified SQL operation — a DELETE, INSERT, or UPDATE — occurs on a table, a trigger can be activated that defines a set of actions.

    当一个指定的SQL操作(如DELETE,INSERT,或者是UPDATE操作)作用于某张表时,一个定义了一组操作的触发器就可以被激活。

    youdao

  • The script starts by connecting to the database. It then executes an INSERT statement against the games table and gets back the ID that was generated.

    此脚本从连接数据库开始,然后对games表执行一条insert语句,并获取生成的ID。

    youdao

  • The import utility uses the SQL INSERT statement (or the SQL UPDATE statement) to write data to the target table.

    import工具使用SQLINSERT语句(或 SQLUPDATE 语句)将数据写到目标表中。

    youdao

  • Release the row locks so that other applications can SELECT, INSERT, UPDATE, and DELETE from the table (for example, use isolation level cursor stability or uncommitted read).

    释放行锁,以便其他应用程序可以对表执行SELECT、INSERT、UPDATE和DELETE(例如,使用游标稳定性(curs or stability)隔离级别或未提交读(uncommitted read)隔离级别)。

    youdao

  • In table 6, the INSERT into the Orders table fails due to a foreign key constraint violation on custno.

    在表6中,对orders表执行insert语句失败,因为custno违背了外键约束。

    youdao

  • Upon arrival, a customer-written program adds the records to a staging table then USES insert statements to add the records to the fact table.

    当该文件到来时,用户编写的一个程序将这些记录添加到一个staging表中,然后使用insert语句将这些记录添加到事实表中。

    youdao

  • Since this is a table operation, tooling generates insert, update, and delete operations automatically.

    由于这是一项表操作,因此工具将自动生成insert、update和delete操作。

    youdao

  • After you create the table, you use one insert statement for each entry in your toppings array.

    创建表后,需要对浇头数组中的每个条目使用一条insert语句。

    youdao

  • The use of a staging table can provide improved performance for some insert scenarios.

    通过使用staging表可以为某些场景下的insert提高性能。

    youdao

$firstVoiceSent
- 来自原声例句
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定
小调查
请问您想要如何调整此模块?

感谢您的反馈,我们会尽快进行适当修改!
进来说说原因吧 确定