MS SQL Server 2012 - DBA Articles

Overview of Data Manipulation Language

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

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)

)

Query Output Screen

* * * * *

Your Comment To AUTHOR