dml

dml

 英

  • 网络数据操作语言(Data Manipulation Language);数据操纵语言;数据操作语句

例句

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

查询设计允许设计SELECTINSERTUPDATEDELETEDML语句视图只能包含SELECT语句

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

分区重叠订阅服务器执行DML更新无法改行所属分区

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

有时这些数据修改语句一并称为SQL数据修改语言DML部分

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

SQL通常称为数据修改语言不能应用程序直接使用

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

前面创建数据库部分SQL控制部分叫做数据控制语言简称DML”。

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

DML触发器经常用于强制执行业务规则数据完整性

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

虽然DML触发器可以引用临时不能临时系统创建DML触发器

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

近期DML公司获得一个独立军事增强计划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触发器用户必须至少创建触发器视图具有ALTER权限

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

说明线程具有权限DML语句类型SELECTINSERTUPDATEDELETE)。

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

DML触发器数据库服务器发生数据操作语言DML事件执行操作

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触发器一行数据加载PurchaseOrderDetail适合单行插入

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

数据库使用SQL称作数据操作语言(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.

处理分区转移分区alter操作生成DML日志记录

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

SQL两个主要部分数据定义语言DDL数据操纵语言DML)。

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

修改CREATETRIGGER语句以前创建DMLDDL登录触发器定义

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语句激发DML触发器触发器执行期间加载插入

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

因此我们描述一些应该记住用于空间查询空间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.

但是无法针对执行获取Sch-M并发DDL操作并发DML操作

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

Performance事件类别包括执行SQL数据操作语言DML运算符生成事件

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

修改以前使用CREATETRIGGER语句创建DMLDDL触发器定义

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

在此过程找出数据差异显示网格然后生成表示这些差异DML脚本

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

同时支持文本节点计算构造函数主要XMLDML使用用于构造文本节点

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

DMX数据定义语言DDL语句数据操作语言DML语句以及函数运算符组成

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

schema_nameDML触发器及其对应视图属于默认架构

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

可以通过使用ALTERTABLE禁用启用定义DML触发器

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

这些计数器索引分区发生各个DML操作实现累加

DDL triggers and DML triggers are used for different purposes.

DDL触发器DML触发器用处不同

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

XML数据修改语言XMLDMLXQuery语言扩展

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

语法正确Xquery表达XMLDML语句返回编译错误

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

引用本地分区视图分布式分区视图远程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.

若要创建DML触发器需要创建触发器视图具有ALTER权限

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

一个复制执行detachfragment操作复制分离分段执行DML操作

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

不能局部全局临时定义DML触发器

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

DML触发器相同可以一个Transact-SQL语句创建多个DDL触发器

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

如果应用程序需要执行许多DML操作必要控制创建索引

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

触发器执行启动其他触发器操作DMLDDL触发器触发器

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

查询执行DML语句每个步骤包括一个物理运算

热门查询