What is DML or Data Manipulation Language Command in SQL Server

Data Manipulation Language (DML):

DML Statements are used for Managing Data within Schema Objects. 

Exmples:

INSERTInsert Data into a Table Fields
UPDATEUpdates Existing Data within a Table Fields
SELECTRetrieve Data from the Database
MERGEMerge Two Field Values (Inert or Update)
CALLCall a PL/SQL Program(Procedural Language for Embedded SQL to PL/SQL
EXPLAINAccess Path to Data 
LOCK TABLEControl Table
DELETEDeletes All Records from a Table Using Conditions.

0 comments:

Post a Comment