Some of the most common errors which occur while executing INSERT statement:-
A).There is a mismatch between the number of columns and the number of values
B).If the datatype of an inserted value is a mismatch with the column of the target table
C).There is a size mismatch between a value and its target column.
D).When a column is defines as not NULL and the insertion value is NULL.
Asked In: Many Interviews |