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