Getting Error while insert the data into table when the column as DEFAULT Constraint on Datetime data type and Insert the

Question

I have create EMP table to insert the data with three columns. I am getting the below error while inserting the data.

Msg 213, Level 16, State 1, Line 6

Column name or number of supplied values does not match table definition.

Could anyone please help me to resolve the issue?

CREATE TABLE EMP ( id int IDENTITY(1,1),Name VARCHAR(10),
    JoiningDate DATETIME
);

ALTER TABLE EMP
ADD CONSTRAINT df_Joindate DEFAULT (getdate())FOR JoiningDate

Answer 1

Hi @Ramana Kopparapu

Column name or number of supplied values does not match table definition.

You're getting this error because the number or name of the columns you're trying to insert data into doesn't match the table definition.

Could you please post your INSERT statement as well? Cause I tested on my side with below code and worked fine.

insert into EMP(Name)
values ('aaaa'),('ccc'),('fff'),('eee')

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Column name or number of supplied values does not match table definition.

The error message has nothing to do with the constraint.

As the message clearly says, the colmuns in the INSERT statement must match with the column values you want to insert.