Monday , December 10 2018
Home / DataBase / SQL SERVER / DATA MANIPULATION LANGUAGE(DML) In Sql Server:

DATA MANIPULATION LANGUAGE(DML) In Sql Server:

DATA MANIPULATION LANGUAGE:

  1. INSERT Statement
  2. SELECT Statement
  3. UPDATE Statement
  4. DELETE Statement

1.INSERT Statement: By Using INSERT Statement   we can inserting the values into a specific table.

2.SELECT Statement: By Using SELECT Statement   we can retrieving the data from a specific table. 

3.UPDATE Statement: By Using UPDATE Statement   we can modifying the data, which is available in a specific table.

4. DELETE Statement: By Using DELETE Statement   we can delete the data from a specific table in ROW-BY-ROW (one by one) manner with out disturbing its structure (columns).

Print Friendly, PDF & Email

Give us your valuable feedback

comments

About Samba

Check Also

sql server backup script

Backup all databases in SQL Instance with one script

Backup: A copy of SQL Server data that can be used to restore and recover the …