Figure 27 shows the Insert SQL statement.
图27显示了Insert sql语句。
The application code used for parsing the XML in the DOM parser and composing the insert SQL statement is replaced with the following code
用来在DOM解析器中解析XML并合成insert SQL语句的应用程序代码被替换为以下代码
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.
这种情况下,解析之需要将数据值从消息的映射数据结构复制到数据库表的INSERT sql语句。
However, they can be resolved if you embed the INSERT statements above in an SQL stored procedure with a little extra logic.
但是,如果将上述insert语句嵌入到一个包含一点额外逻辑的SQL存储过程中,就可以解决这个问题。
It's a simple INSERT statement where the two values are escaped to account for any errant characters such as single quotes that might disturb the SQL syntax.
就是在简单的insert语句中,两个值被转义,以解决任何含义不确定的字符,比如说可能会扰乱sql语法的单引号。
At some level, the SQL UPDATE statement is the union of the SQL INSERT and DELETE statements, because you must select rows to modify as well as specify how to modify them.
在某种程度上,SQLupdate语句是SQL INSERT和delete语句的联合,因为您必须选择要修改的行,还必须指定如何修改它们。
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个表执行SQL INSERT。
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 完成操作。
In most cases, well-suited SQL statements are very simple SELECT statements that reference only a single table or are INSERT, UPDATE, and DELETE (UID) operations that are executed many times.
在大多数情况下,非常适合使用参数标记的sql语句要么是非常简单的SELECT语句(只引用一个表),要么是被多次执行的INSERT、UPDATE和DELETE (uid)操作。
Being an SQL statement, an INSERT statement must be compiled by DB2 before it's executed.
作为一条sql语句,insert语句在执行之前必须由DB 2进行编译。
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)。
The XML element names correspond to the type of SQL statements you would expect them to — the elements correspond to SQL INSERT statements and so on.
这些XML元素名对应于SQL语句的类型 —元素对应于 SQL INSERT 语句,以此类推。
You can also add data by using SQL insert commands.
您还可以通过使用SQL命令insert 来添加数据。
Additional information on the insert can usually be found in the dynamic SQL snapshot.
通常在动态sql快照中可以找到关于insert的附加信息。
In Listing 4, you see that one SQL insert statement is used for each of the four tables in the simple relational schema.
在清单4中可以看到,对于简单关系模式中的4个表中的每一个表,都使用了一个SQL insert语句。
These re-usable data adapters can have select, update, insert, and delete commands that are either SQL statements or stored procedure calls.
这些可重用数据适配器可以拥有select、update、insert和delete命令,它们或者是sql语句,或者是存储过程调用。
The SQL code in the insert statements has one feature you may not be expecting.
insert语句中的SQL代码有一个您可能不需要的功能。
For each IfxDataAdapter, define the SQL text and parameters for the select, insert, update, and delete commands.
对于每个IfxDataAdapter,需要定义SQL文本,并为select、insert、update和delete命令定义参数。
The insert and update methods are a bit more complex because they need to format the SQL statements with additional fields for the input data.
insert和update方法要复杂一些,因为它们需要使用用于输入数据的额外字段格式化sql语句。
From an SQL perspective, the merge statement is a DML SQL statement with the same semantics as other DML statements, including insert, update, and delete.
从SQL的角度看,merge语句是与其他dml语句具有相同语义的DML sql语句,包括insert、update、以及delete。
It provides the functions for executing the SQL select/insert/update/upsert/delete statements via the Teradata DBC/SQL partition.
它提供了通过TeradataDBC/SQL分区执行 SQLselect/insert/update/upsert/delete语句的功能。
Add data to the table using SQL INSERT statements.
使用SQL insert语句将数据添加到表中。
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操作)作用于某张表时,一个定义了一组操作的触发器就可以被激活。
Specifications for the representation of SQL actions (insert, update, delete).
SQL动作(insert、update、delete)表示的规范。
These two variations correspond to the INSERT and UPDATE commands in SQL.
这两种变体分别对应于SQL中的INSERT和UPDATE命令。
The import utility uses the SQL INSERT statement (or the SQL UPDATE statement) to write data to the target table.
import工具使用SQL INSERT语句(或 SQLUPDATE 语句)将数据写到目标表中。
MODIFIES SQL DATA in SQL table functions allows you to push even INSERT, UPDATE, DELETE and MERGE (data-change-operations) into the inner leg of correlated joins.
SQL表函数中的 MODIFIES SQLDATA使您甚至可以将INSERT、UPDATE、DELETE和MERGE ( 数据更改操作)放入到关联连接的内表中。
At 15,000 R6Mail users, the DB2 server is executing an average of 160,000 SQL statements per minute, including the SELECT, INSERT, DELETE, and UPDATE statements.
有15,000个R 6 Mail用户时,DB 2服务器平均每分钟执行160,000个sql语句,其中包括SELECT、INSERT、DELETE和update语句。
Ability to execute standard SQL statements such as SELECT, INSERT, UPDATE, and DELETE, combinations of these statements, user-defined SQL, as well as bulk load.
能够执行SELECT、INSERT、UPDATE和DELETE等sql语句和sql语句组合、用户定义的sql语句以及整体加载语句。
SELECT, however, isn't the only SQL statement supported by YQL; you can also use INSERT, DELETE, and UPDATE queries to manipulate data on third-party services using the same SQL syntax.
但是,SELECT并非YQL支持的惟一SQL语句;您还可以使用INSERT、DELETE和UPDATE查询、运用相同的 SQL语法操作第三方服务上的数据。
应用推荐