The INSERT statement inserts a row into a database table.
A single row is inserted into the table identified by TableReference.
The ColumnName list identifies those columns in the target
table that are to be given specific values. These values are determined by
the expressions within the VALUES clause (the first expression gives the value
of the first named column, and so on). The number of expressions in the VALUES
clause must be the same as the number of named columns. Any columns present
in the table but not mentioned in the list are given their default values.
It is possible for errors to occur during insert operations. For example, the database may not be operational, or the table may have constraints defined which the new row would violate. In these cases, an exception is thrown (unless the node has its throw exception on database error property set to FALSE). These exceptions set appropriate SQL code, state, native error, and error text values and can be dealt with by error handlers (see the DECLARE HANDLER statement).
For further information about handling database errors, see Capturing database state.
The following example assumes that the dataSource property of the Database node has been configured, and that the database it identifies has a table called TABLE1 with columns A, B, and C.
<A> <B>1</B> <C>2</C> <D>3</D> </A>