dml

美 　英

• 網(wǎng)絡(luò)數(shù)據(jù)操作語言(Data Manipulation Language)；數(shù)據(jù)操縱語言；數(shù)據(jù)操作語句

例句

Query Designer allows you to design SELECT, INSERT, UPDATE and DELETE DML statements, while views can only contain SELECT statements.

查詢設(shè)計(jì)器允許設(shè)計(jì)SELECT、INSERT、UPDATE和DELETEDML語句，而視圖只能包含SELECT語句。

The partitions are overlapping, and DML updates made at the Subscriber cannot change the partition to which a row belongs.

分區(qū)是重疊的，訂閱服務(wù)器上執(zhí)行的DML更新無法更改行所屬的分區(qū)。

Sometimes , the data modification statements are collectively known as the data modification language (DML) part of SQL .

有時，這些數(shù)據(jù)修改語句被一并稱為SQL的數(shù)據(jù)修改語言（DML）部分。

SQL is also commonly known as a DML, but it cannot be directly used from an application program.

SQL通常也被稱為數(shù)據(jù)修改語言，但它不能由應(yīng)用程序直接使用。

As mentioned previously in the section "Creating a Database, " the manipulative component of SQL is called Data Manipulation Language (DML).

像前面“創(chuàng)建數(shù)據(jù)庫”部分所講的，SQL的控制部分叫做數(shù)據(jù)控制語言，簡稱“DML”。

DML triggers are frequently used for enforcing business rules and data integrity.

DML觸發(fā)器經(jīng)常用于強(qiáng)制執(zhí)行業(yè)務(wù)規(guī)則和數(shù)據(jù)完整性。

A DML trigger cannot be created on a temporary or system table, although DML triggers can reference temporary tables.

雖然DML觸發(fā)器可以引用臨時表，但不能對臨時表或系統(tǒng)表創(chuàng)建DML觸發(fā)器。

DML has also recently been awarded a separate contract for a number of MEP (Military Enhancement Programme) vehicles.

近期，DML公司還獲得了一個獨(dú)立的軍事增強(qiáng)計(jì)劃（MEP）車輛合同。

To disable a DML trigger, at a minimum, a user must have ALTER permission on the table or view on which the trigger was created.

若要禁用DML觸發(fā)器，用戶必須至少對為其創(chuàng)建觸發(fā)器的表或視圖具有ALTER權(quán)限。

Describes the type of DML statement (SELECT, INSERT, UPDATE, or DELETE) on which the threads have permissions.

說明線程對其具有權(quán)限的DML語句的類型（SELECT、INSERT、UPDATE或DELETE）。

A DML trigger is an action programmed to execute when a data manipulation language (DML) event occurs in the database server.

DML觸發(fā)器是當(dāng)數(shù)據(jù)庫服務(wù)器中發(fā)生數(shù)據(jù)操作語言（DML）事件時要執(zhí)行的操作。

The first version of the DML trigger works well for a single-row insert when a row of data is loaded into the PurchaseOrderDetail table.

第一種DML觸發(fā)器在一行數(shù)據(jù)加載到PurchaseOrderDetail表中時適合于單行插入。

The database classes use a portion of SQL known as the Data Manipulation Language (DML).

數(shù)據(jù)庫類使用SQL中稱作數(shù)據(jù)操作語言（DataManipulationLanguage，DML）的那部分。

Process DML log records generated due to an alter operation while moving the rows from the old partition to the new table partition.

處理在將舊分區(qū)中的行轉(zhuǎn)移到新表分區(qū)時因alter操作而生成的DML日志記錄。

SQL has two main components: a Data Definition Language (DDL) and a Data Manipulation Language (DML).

SQL有兩個主要部分：數(shù)據(jù)定義語言（DDL）和數(shù)據(jù)操縱語言（DML）。

Modifies the definition of a DML, DDL, or logon trigger that was previously created by the CREATE TRIGGER statement.

修改CREATETRIGGER語句以前創(chuàng)建的DML、DDL或登錄觸發(fā)器的定義。

An INSERT statement fires the DML trigger, and the new row is loaded into the inserted table for the duration of the trigger execution.

INSERT語句激發(fā)DML觸發(fā)器，新行在觸發(fā)器執(zhí)行期間加載到插入的表中。

Subsequently, we describe a few concepts that you should keep in mind for spatial queries and spatial DML statements.

因此，我們描述一些您應(yīng)該記住的用于空間查詢和空間DML語句的概念。

The isolation level can be overridden for individual query or DML statements, if necessary, by specifying a table-level hint.

必要時，可以通過指定表級提示來替代各個查詢語句或DML語句的隔離級別。

However, concurrent DDL operations, and concurrent DML operations that acquire Sch-M locks, cannot be performed on the table.

但是，無法針對表執(zhí)行獲取Sch-M鎖的并發(fā)DDL操作和并發(fā)DML操作。

The Performance Event Category includes event classes that are produced when SQL data manipulation language (DML) operators execute.

Performance事件類別包括在執(zhí)行SQL數(shù)據(jù)操作語言（DML）運(yùn)算符時生成的事件類。

Modifies the definition of a DML or DDL trigger that was previously created by the CREATE TRIGGER statement.

修改以前使用CREATETRIGGER語句創(chuàng)建的DML或DDL觸發(fā)器的定義。

In this procedure, you find differences in data, display them in a grid, and generate a DML script that expresses them.

在此過程中，您將找出數(shù)據(jù)中的差異，將其顯示在網(wǎng)格中，然后生成表示這些差異的DML腳本。

Computed constructors for text nodes are also supported, but are primarily used in XML DML to construct text nodes.

同時還支持文本節(jié)點(diǎn)的計(jì)算構(gòu)造函數(shù)，但主要在XMLDML中使用，用于構(gòu)造文本節(jié)點(diǎn)。

DMX is composed of data definition language (DDL) statements , data manipulation language (DML) statements, and functions and operators .

DMX由數(shù)據(jù)定義語言（DDL）語句、數(shù)據(jù)操作語言（DML）語句以及函數(shù)和運(yùn)算符組成。

Schema_name is optional only if the DML trigger and its corresponding table or view belong to the default schema.

schema_name僅在DML觸發(fā)器及其對應(yīng)的表或視圖屬于默認(rèn)架構(gòu)時可選。

DML triggers defined on tables can be also be disabled or enabled by using ALTER TABLE.

還可以通過使用ALTERTABLE來禁用或啟用為表所定義的DML觸發(fā)器。

These counters are incremented by the respective DML operation occurring on the partition, both table and index partitions.

這些計(jì)數(shù)器由表和索引分區(qū)中發(fā)生的各個DML操作實(shí)現(xiàn)值累加。

DDL triggers and DML triggers are used for different purposes.

DDL觸發(fā)器和DML觸發(fā)器的用處不同。

The XML Data Modification Language (XML DML) is an extension of the XQuery language.

XML數(shù)據(jù)修改語言（XMLDML）是XQuery語言的擴(kuò)展。

Compilation errors are returned from syntactically incorrect Xquery expressions and XML DML statements.

語法不正確的Xquery表達(dá)式和XMLDML語句會返回編譯錯誤。

DML statements that reference local partitioned views, distributed partitioned views, or remote tables.

引用本地分區(qū)視圖、分布式分區(qū)視圖或遠(yuǎn)程表的DML語句。

DML statements can have up to two children.

DML語句最多可以有兩個子級。

To create a DML trigger requires ALTER permission on the table or view on which the trigger is being created.

若要創(chuàng)建DML觸發(fā)器，則需要對要創(chuàng)建觸發(fā)器的表或視圖具有ALTER權(quán)限。

Replicate DML operations performed on the detached fragment after a detach fragment operation on a replicated table.

在對一個復(fù)制表執(zhí)行detachfragment操作后，復(fù)制在被分離分段上執(zhí)行的DML操作。

DML triggers cannot be defined on local or global temporary tables.

不能對局部或全局臨時表定義DML觸發(fā)器。

Like DML triggers, more than one DDL trigger can be created on the same Transact-SQL statement.

與DML觸發(fā)器相同，可以為同一個Transact-SQL語句創(chuàng)建多個DDL觸發(fā)器。

If your application performs many DML operations, you should be conservative with the number of indexes you create.

而如果您的應(yīng)用程序需要執(zhí)行許多DML操作，就有必要控制創(chuàng)建的索引數(shù)了。

Both DML and DDL triggers are nested when a trigger performs an action that initiates another trigger.

當(dāng)觸發(fā)器執(zhí)行啟動其他觸發(fā)器的操作時，DML和DDL觸發(fā)器都是嵌套觸發(fā)器。

Each step in the execution of a query or DML statement involves a physical operator.

查詢執(zhí)行或DML語句中的每個步驟都包括一個物理運(yùn)算符。