SQL - Structured Query Language |
INSERT Statement / All Column(s)INSERT Statement is used to ADD one or more record(s) to a table or a view in SQL Server 2012. INSERT Statement occurs error, while violates a constraint rule or mismatched data type of the column. The following INSERT statement is used to add record in PRODUCT Table. --
Example 16 -- INSERT INTO Product VALUES ('PROD1','Product A',12345,'12-31-2007',15,'Remark A') INSERT INTO Product (Prod_Code, Prod_Name, Batch_No, Exp_Date, Prod_Tax, Remarks)
VALUES
('PROD2','Product B',12345,'12-31-2007',15,'Remark B') |
* * * * *