You are inserting some values into Table but your Insert Statements Fails.So what may be the reasons?

Answer:

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.