图4您可以修改语句中址来解决不兼容性。
Figure 4 You can modify statements in SSMA to resolve incompatibilities.
应用程序准备(编译)好一条语句之后,可以修改语句对象——表、索引、统计信息。
After a statement has been prepared (compiled) by the application, the statement objects — tables, indexes, statistics — can be altered.
如果NOT LOGGED表在执行数据修改语句期间碰到了执行错误,那么对于DB 2来说,就只有一个选择:清空(truncate)该表。
If a NOT LOGGED table encounters an execution error during a data changing statement there is only one choice for DB2: to truncate the table.
这意味着对于每种数据库,我们将修改基本的CRUDsql语句。
This means we will modify the basic CRUD SQL statements for each database.
这两个sql语句作为文本比较,以便轻松查看并修改。
The two SQL statements are compared as text for easy viewing and modification.
要想调整此方法以支持全局重置,只需修改表创建语句,让它们创建常规表而不是CGTT。
To adapt the method to support global reset, simply change the table creation statements to create regular tables rather than CGTTs.
虽然这个特例的后果可能并不太严重,但完全有可能添加更恶意的代码,尤其是会修改表的DELETE或update语句。
While this particular example might not be considered severe, other more malicious code could be added, especially DELETE or UPDATE statements that modify tables.
因为希望对目标数据库mysample执行下面的语句,所以要相应地修改CONNECT语句。
As you want to execute the following statements against the target database MYSAMPLE, you alter the CONNECT statement accordingly.
来自HTTP请求的客户个人数据作为参数传递给更新语句;不需要修改。
The customer profile data from the HTTP request is passed as a parameter to the update statement; no modifications are needed.
尤其是,对于范围分区表,仍然可以使用以前支持的创建和修改表的sql语句。
In particular, the previously supported SQL statements for creating and altering tables for range partitioning as well as attaching and detaching partitions still apply.
全局变量表示一个可以使用sql语句访问和修改的可变值。
A global variable is a representation of a changeable value which can be accessed and modified using SQL statements.
在这个例子中,我们选择修改CREATEprocedure语句而不是修改源代码。
In this example, we have chosen to fix the CREATE PROCEDURE statement instead of modifying the source code.
然后使用SQLupdate语句来修改表中选定行的列值。
Next you used the SQL UPDATE statement to modify the column values for selected rows in a table.
如果已经修改了users表的模式,那么一定要对insert语句进行相应的修改。
If you have modified the Users table schema, be sure to make the matching changes to the Insert statement.
这时,真正的应用程序将通过执行必要的SQLupdate语句来适当修改count列。
At this point, a real application would modify the count column appropriately by issuing the necessary SQL UPDATE statements.
还有重要的一点需要指出,即我对清单5所示的代码底部的if - then语句做了稍许修改。
It's also important to note that I made a slight change to the if-then statement at the bottom of the code in Listing 5.
remaster复制定义,修改复制select语句,以便为新添加的列复制数据。
Remaster the replicate definition and modify the replicate SELECT statement to replicate data for the newly-added column.
通过使用PreparedStatement,可以在运行时动态修改sql语句。
By using a PreparedStatement, you can dynamically modify your SQL statement at run time.
再次调用HISTORY命令来显示缓存中现在有5个命令,包括修改的SELECT语句。
Invoking the HISTORY command again shows that there are now five commands or statements in the cache, including the modified SELECT statement.
管理员还可以通过使用ALTERTRUSTEDCONTEXT和DROP TRUSTED context语句修改和删除受信任上下文对象。
The administrator can also alter and drop the trusted context object by using alter trusted context and drop trusted context statements.
在ceadojo/acme/widget/ClickToCall.js 的源代码中,您将修改几个声明语句和一个require语句。
In the source of the ceadojo/acme/widget/ClickToCall.js you'll change the declaration statements and a require statement.
用户可以使用SETCURRENTschema语句修改特殊寄存器CURRENT SCHEMA的值。
The value of the CURRENT SCHEMA special register can be modified by the user with the SET CURRENT SCHEMA statement.
在这样的情况下,如图2所示,您必须在SchemaLibraryManager中将已引用文件的文件位置属性修改为include语句使用的位置。
In cases like this, you must modify the file location attribute, as shown in Figure 2, of the referenced file in the Schema Library Manager to the location used by the INCLUDE statements.
最直观的反应就是代码只需作细微的修改;在“for”语句内的代码块,可以作为参数传递到“Parallel.For”函数中。
Superficially the code changes are minor; rather than having a block of code following the "for" line, the code is passed as an argument to the "Parallel.For" function.
pagefreespace的值比该表中可由ALTERTABLE 语句来修改的PCTFREE参数值具有更高的优先权。
The pagefreespace value takes precedence over the value of the PCTFREE parameter for the table, which can be changed through the ALTER TABLE statement. create table newemp like employee;
因为这三种语句都会修改数据,所以用这个首字母缩写作为它们的统称。
Since all three statements modify data, it's useful to have an acronym for referring to all of them.
当您在一个已经包含了语句的SQL脚本中设置语句结束符时,编辑器不会自动修改原有的语句结束符。
When you set the statement terminator in an SQL script that contains existing statements, the editor does not update the existing statement terminators automatically.
可以使用生成的soql语句,或者手动地修改该语句。
You can use the generated SOQL statement as is, or manually modify it.
极易对每个DB 2存储过程中使用的sql语句进行修改,以满足特定您的特定需要。
The SQL statement used in each DB2 Stored Procedure can be modified very easily to satisfy your specific needs.
可以在程序划分语句中引用LINAGE - COUNTER;但不能用这些语句修改它。
LINAGE-COUNTER can be referred to in procedure division statements; it must not be modified by them.
应用推荐