To use this database, we need to insert some data into the table.
要使用这个数据库,我们需要向表中插入一些数据。
Given the number of INSERT, UPDATE, and DELETE operations and changes in data distributions, you need to collect the right statistics regularly and with minimum resource consumption.
您需要根据INSERT、UPDATE和DELETE操作的数目和数据分布的变化,在资源消耗尽量少的情况下定期收集正确的统计数据。
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数据。
I wrote a.net program to parse through the file and build INSERT statements for the data.
我编写了一个. NET程序来解析这个文件并为数据构建insert语句。
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语句通常会失败,这是因为每个事务的数据超过了数据库系统里的日志文件的容量。
Our experimentation suggests that when relatively large amounts of data need to be loaded into the MQT, load performs faster than INSERT.
我们的试验表明,当需要将相对较大的数据加载到MQT中时,LOAD执行得比INSERT更快。
INSERT adds the input data to the table without changing any existing data.
INSERT将输入数据添加到表中,并且不更改任何现有数据。
INSERT mode adds the input data to the table without changing any existing data.
INSERT模式添加输入数据到表中,并且不会更改任何现有数据。
This makes DB2 behave as one would expect: the scanner waits until the INSERT transaction commits or rolls back and then return the data - business as usual.
这使得DB2 的行为和预期的一样:扫描器一直等到INSERT事务提交或回滚,然后返回数据 —— 这和平常一样。
Bulk data handling techniques which utilize SQL blocked FETCH and INSERT to overcome traditional operations (i.e. READE) that cannot be blocked.
大数据处理技术,该技术利用sql块操作的FETCH和INSERT来克服不能被块操作的传统操作(例如READE)。
Using the data mashup editor, you could create a data mashup with a FOREACH operator to INSERT content from each repeating entry into its own row.
使用数据混搭编辑器,就可以创建一个混搭应用,用FOREACH操作符将内容从每个报表条目 INSERT到各自的行中。
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语句定义示例表和数据。
In this case, the only parsing is copying the data values from the message's mapped data structure to the database table's INSERT SQL statement.
这种情况下,解析之需要将数据值从消息的映射数据结构复制到数据库表的INSERTsql语句。
For INSERT, UPDATE, and DELETE queries involving nicknames, in some cases (explained below), all the work might be done by the remote data source, and a SHIP operator will not be found in the FQEP.
对于使用了昵称的INSERT、UPDATE和DELETE查询,在某些情况下(后面会解释),所有工作可能都是由远程数据源来做,而在FQEP中没有ship操作符。
Should the update to the ACCT table fail, there would be no mechanism to roll back the insert to the TRADE table, resulting in inconsistent data in the database.
若acct表更新失败,没有任何机制可以回滚到对trade表的更新操作,从而造成数据库中的数据不一致。
Add data to the table using SQL INSERT statements.
使用SQLinsert语句将数据添加到表中。
The data is copied by using either INSERT FROM CURSOR, which is the default, or LOAD if the correct option is set.
数据可以通过使用INSERTFROM CURS OR(默认设置)复制,也可以通过LOAD复制(如果设置了正确的选项的话)。
As shown in Listing 5, the revised INSERT statement invokes the XMLValidate function before specifying a parameter marker for the XML data.
如清单4所示,修订后的insert语句在为XML数据指定参数标志符之前调用xmlvalidate函数。
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能够确保索引始终与表数据一致。
The import utility uses the SQL INSERT statement (or the SQL UPDATE statement) to write data to the target table.
import工具使用SQLINSERT语句(或 SQLUPDATE 语句)将数据写到目标表中。
Populating the database with XML data using INSERT and IMPORT statements.
使用INSERT和import语句,用XML数据填充数据库。
Also, BEFORE triggers can now contain UPDATE, DELETE, INSERT and routines that modify data.
另外,BEFORE触发器现在可以包含UPDATE、DELETE、INSERT和修改数据的例程。
Write access rules are applied when data is written (INSERT, UPDATE, and DELETE operations) and can be summarized as follows.
当用户写数据时(INSERTUPDATE和DELETE操作),则应用写访问规则,写访问规则可总结如下。
And follow up with populating the DEPARTMENT table with the data delineated in table 2 with an INSERT command such as.
再通过如下insert命令用表2给出的数据填充DEPARTMENT填充。
Use TRY..CATCH construct or check the @@ERROR variable after executing a data manipulation statement (like INSERT/UPDATE/DELETE).
在执行数据操作语句(像INSERT/UPDATE/DELETE)之后,使用TRY..CATCH结构或者检查该@@ERROR变量
To avoid too much complexity, DB2 imposes a simple rule: an UPDATE, DELETE or INSERT (data-change-operation) shall never happen in a join unless embedded in a correlated function.
为了避免太多的复杂性,DB 2强加了一条简单的规则:除非嵌入在相关的函数里面,否则UPDATE、DELETE或INSERT(数据更改操作)不应该出现在连接中。
Static search set is an abstract data type with the operations initialize, insert, and retrieve.
静态搜索集是一种抽象数据类型,包含的操作包括initialize、insert和retrieve。
You can also add data by using SQL insert commands.
您还可以通过使用SQL命令insert 来添加数据。
The previous examples are fairly simple, but GroovySql is just as solid when it comes to more complex data manipulation queries such as insert, update, and delete queries.
前面的例子相当简单,但是GroovySql在处理更复杂的数据操纵查询(例如insert、update和delete查询)时,也是非常可靠的。
The previous examples are fairly simple, but GroovySql is just as solid when it comes to more complex data manipulation queries such as insert, update, and delete queries.
前面的例子相当简单,但是GroovySql在处理更复杂的数据操纵查询(例如insert、update和delete查询)时,也是非常可靠的。
应用推荐