MS SQL Server Concepts and Programming Question: Download Questions PDF
What Are DML (Data Manipulation Language) Statements in MS SQL Server?
Answer:
DML (Data Manipulation Language) statements are statements to change data values in database tables. The are 3 primary DML statements:
* INSERT - Inserting new rows into database tables. For example "INSERT INTO ggl_links VALUES (101, 'www.globalguideline.com', NULL, 0, '2006-04-30')" inserts a single new row in the ggl_links table.
* UPDATE - Updating existing rows in database tables .
* DELETE - Deleting existing rows from database tables.
* INSERT - Inserting new rows into database tables. For example "INSERT INTO ggl_links VALUES (101, 'www.globalguideline.com', NULL, 0, '2006-04-30')" inserts a single new row in the ggl_links table.
* UPDATE - Updating existing rows in database tables .
* DELETE - Deleting existing rows from database tables.
Download MS SQL Server Interview Questions And Answers
PDF
Previous Question | Next Question |
How To Drop an Existing Table with "DROP TABLE" Statements in MS SQL Server? | How To Create a Testing Table with Test Data in MS SQL Server? |