{"id":15,"date":"2011-06-27T09:49:56","date_gmt":"2011-06-27T09:49:56","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2011\/06\/27\/dml-data-manipulation-language-sql-server\/"},"modified":"2011-06-27T09:49:56","modified_gmt":"2011-06-27T09:49:56","slug":"dml-data-manipulation-language-sql-server","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2011\/06\/27\/dml-data-manipulation-language-sql-server\/","title":{"rendered":"DML &#8211; Data manipulation language &#8211; SQL SERVER"},"content":{"rendered":"<p>DML<\/p>\n<p>Abbreviation: Data manipulation language<\/p>\n<p>DML is used to insert, update, delete and select records from a table.<\/p>\n<p>DML Statements change the data in the database but does not effect the structure of the objects.<\/p>\n<p>DML Statements\u00a0 are transaction controlled, they can be committed or\u00a0rolled back in a transaction.<\/p>\n<p>What can DDL Statements Do?<\/p>\n<p>Following are the DML Statements:<\/p>\n<ul>\n<li>Select<\/li>\n<li>Insert<\/li>\n<li>Update<\/li>\n<li>Delete<\/li>\n<\/ul>\n<p>Example:<\/p>\n<p><code>SELECT * FROM EMPLOYEE<\/code><\/p>\n<p>The above query gives the result set which contains all the records in the table<\/p>\n<p><code>INSERT INTO EMPLOYEE VALUES (3,\u2019Ram\u2019)<\/code><\/p>\n<p>The above query inserts one record into employee table, employee number as 3 and name as Ram.<\/p>\n<p><code><br \/>\nUPDATE EMPLOYEE SETNAME = \u2018PAUL\u2019 WHERE EMPLOYEEID = 2<br \/>\n<\/code><\/p>\n<p>The above query updates the employee name of the employee with employee id as 3 to PAUL<\/p>\n","protected":false},"excerpt":{"rendered":"<p>DML Abbreviation: Data manipulation language DML is used to insert, update, delete and select records from a table. DML Statements change the data in the database but does not effect the structure of the objects. DML Statements\u00a0 are transaction controlled, they can be committed or\u00a0rolled back in a transaction. What can DDL Statements Do? Following&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41,3],"tags":[54,55,56,57,58,59],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/15"}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=15"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/15\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=15"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=15"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=15"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}