|
|
|
| MS SQL Server 2012 - DBA Articles |
INSERT - Add Particular Columns of RecordSequence of fields may know, while add record(s) to a table. Type 0 value, if you do not know for a numeric field. Type NULL value, if you do not know for a string field. If the particular column is NOT NULL, the INSERT or UPDATE statement fails and occurs error. The following INSERT statement is used to add particular columns record in PRODUCT Table. -- Example 17 --
INSERT INTO Product (Prod_Code, Prod_Name, Batch_No, Exp_Date, Prod_Tax, Remarks) VALUES ('PROD3','',12345,'12-31-2007',0,NULL) Query Output Screen |
* * * * *
|
|
|
|
Copyrights © . Data-e-Education. All Rights Reserved.
Your Comment To AUTHOR