|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.
Query Output Screen
* * * * *