Inserting Rows with NULL Column Values

Go Up to Inserting Data (Embedded SQL Guide)

Sometimes when a new row is added to a table, values are not necessary or available for all its columns. In these cases, a NULL value should be assigned to those columns when the row is inserted. There are three ways to assign a NULL value to a column on insertion:

• Ignore the column.
• Assign a NULL value to the column. This is standard SQL practice.
• Use indicator variables.

Topics

• Ignoring a Column
• Assigning a NULL Value to a Column
• Using Indicator Variables