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')

Query Output Screen

* * * * *

Email Your Comment To AUTHOR