SQL - Structured Query Language

DML Statements



Data Manipulation Language - DML is used to Add, Modify, Query or Delete record(s) in SQL Server 2012.

List of DML Statements

INSERT BULK INSERT
SELECT MERGE
UPDATE UPDATETEXT
DELETE READTEXT
- WRITETEXT

List of Clause in DML Statements

Clause Can be used in DML Statements
FROM DELETE / SELECT / UPDATE
HINTS DELETE / INSERT / SELECT / UPDATE
OPTION Clause DELETE / SELECT / UPDATE
OUTPUT Clause DELETE / INSERT / MERGE / UPDATE
Search Condition DELETE / MERGE / SELECT / UPDATE
Table Value Constructor FROM / INSERT / MERGE
TOP DELETE / INSERT / MERGE / SELECT / UPDATE
WHERE DELETE / SELECT / UPDATE
WITH CTE
common table expression
DELETE / INSERT / MERGE / SELECT / UPDATE


More Reference URL: http://technet.microsoft.com/en-us/library/ff848766.aspx

Note: For Demo, Please create PRODUCT Table in EBusiness Database.

-- Example 15 --

 

CREATE TABLE Product

(

Prod_Code varchar(5) NOT NULL,

Prod_Name varchar(50) NOT NULL,

Batch_No numeric(10) NOT NULL,

Exp_Date datetime NOT NULL,

Prod_Tax numeric(5) NOT NULL,

Remarks varchar(255)

)

GO



Query Output Screen





* * * * *


Email Your Comment To AUTHOR