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

 Posted by vishalneeraj-24503 on 7/31/2014 | Category: Sql Server Interview questions | Views: 244 | Points: 40
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.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response