MS SQL Server 2012 - DBA Articles | ||||||||||||||||||||||||||||||
Overview of Data Manipulation LanguageData Manipulation Language - DML is used to Add, Modify, Query or Delete record(s) in SQL Server 2012. List of DML Statements
--
Example 15 -- CREATE TABLE Product ( Prod_Code varchar(5) NOT NULL, Prod_Name varchar(50) NOT NULL, Batch_No numeric(10) NOT NULL, Exp_Date datetime NOT NULL, Prod_Tax numeric(5) NOT NULL, Remarks varchar(255) ) GO |
* * * * *