Once the rows are sorted, the algorithm for joining the two tables is easy: the database server simply reads both sorted tables sequentially and merge all rows if they are matching.
一旦实现了对行的分类,连接两个表的算法就十分容易:数据库服务器仅仅连续地读取两个已分类表,并合并所有相匹配的行。
UPDATE is an INSERT, UPDATE, DELETE, or MERGE operation that may have input parameters and that returns an integer (number of affected rows).
更新是一个INSERT、UPDATE、DELETE或MERGE操作,可以有输入参数,返回一个整数(受影响的行数)。
You can use the --extratargetrows option with either of these three options: keep, delete, and merge to specify how to handle duplicate rows.
可以使用 --extratargetrows选项,加上keep、delete和merge这三个选项中的一个,来规定如何处理重复行。
When you try to merge at line 21, you get the result 0 rows merged because the check constraint is violated.
当想在第21行进行合并时,会得到结果0rows merged因为检查约束发生了冲突。
The name of an automatically-generated stored procedure that the Merge Agent USES to accomplish locking, and finding columns and rows for an article.
自动生成的存储过程的名称,合并代理使用该存储过程完成锁定并查找项目的行和列。
Conceptually, the merge function joins source table rows with target table rows by applying the on clause filter. All the joined rows are updated or deleted on the target.
从概念上说,merge函数通过应用on子句过滤,将源表行与目标表行进行联接,所有联接的行都在目标中进行更新或者删除。
In the first merge statement, all the non-matching rows would be ignored and matched rows would be updated in the sale table.
在第一个merge语句中,所有未匹配的行将被忽略,而销售表中匹配的行将被更新。
The merge statement first does a join (outer join or inner join, depending on the merge statement) between source and target table rows.
merge语句首先进行(外部联接或者内部联接,取决于merge语句)源与目标表行之间的联接。
You can only merge two rows when number of cells and sizes are the same.
单元格数目和大小相同时,只能合并两行。
If you are using the RBO, then a merge join is the most efficient join when a join returns a large number or rows.
如果你使用RBO方式,那么一个合并连接是最有效的连接,当一个连接返回一个大数量或行。
If you are using the RBO, then a merge join is the most efficient join when a join returns a large number or rows.
如果你使用RBO方式,那么一个合并连接是最有效的连接,当一个连接返回一个大数量或行。
应用推荐