MS SQL Server 2012 - DBA Articles

INSERT - Add Particular Columns of Record



Sequence 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



* * * * *


Email Your Comment To AUTHOR