|
|
|
| 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 |
* * * * *
|
|
|
|
Copyrights © . Data-e-Education. All Rights Reserved.
Your Comment To AUTHOR