Showing posts with label DML. Show all posts
Showing posts with label DML. Show all posts

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.