SQL Server 2

DML:-

----Data  Manipulation Language.
----These commands are used to work on data in tables.
  

They Can be Remembered as SUDI.

S-Select
U-Update
D-Delete
I- Insert

SELECT:-

Ex:- 

SELECT * FROM PS_AAPENG_TBL ORDER BY ANAME
SELECT EMPLID,SALARY FROM PS_DEMO_TBL

UPDATE:-

Ex:-

UPDATE PS_J_DEMO SET EMPLID='E002' WHERE EMPLID='E001'

DELETE:-

Ex:-

DELETE FROM PS_DEMO_TBL

DELETE FROM PS_AAPENG_TBL WHERE ASALARY='20000'

INSERT:-

Ex:-

INSERT INTO PS_J_DEMO  VALUES('E001','XXX','12/07/2014',15000)

INSERT INTO PS_J_DEMO (EMPLID,NAME,DOJ,SALARY) VALUES('E001','XXX','12/07/2014',15000)