惟一需要注意的其他事项是,可以、也应该在 CREATE TABLE 语句后面添加一个子句,以指定将表放在哪个数据库中。
The only other noticeable difference is that an additional clause can and should be appended to the CREATE TABLE statement to specify in which database the table shall be placed.
清单5展示了merge语句的其他的使用情况,其中WHEN MATCHED和WHEN NOT matched子句是可选的。
Listing 5 shows other usages of the merge statement where the WHEN MATCHED and WHEN NOT MATCHED clauses are optionally used.
最后,在这个事务中还暴露了有关数据更改操作的另一个更新颖的特性:那就是INCLUDE -子句,像任何其他数据更改语句一样,INSERT可以使用这个子句。
Finally, there is one more novel feature related to data-change-operations exposed in this transaction: the INCLUDE-clause which INSERT, like any other data-change-operation, can use.
应用推荐