Wednesday , January 17 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

Find all rows count and columns count in single database in sql server

In General for any database it contains lot of tables, if we want to find …

%d bloggers like this: