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

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008R2

MS SQL SERVER 2008 - R2 Database

drop table #trial

create table #trial ( names varchar(10) ,
subject varchar(10) ,
marks varchar(10)
)

insert into #trial values ('ama' , 'maths' ,'A20')
insert into #trial values ('kay' , 'maths' ,'A30')
insert into #trial values ('kay' , 'geog' ,'A40')
insert into #trial values ('joh' , 'maths' ,'A50')
insert into #trial values ('joh' , 'geog' ,'A60')
insert into #trial values ('joh' , 'physics' ,'A70')
insert into #trial values ('ros' , 'english' ,'A80')

select * from #trial

Error

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

What am I doing wrong ?

What I have tried:

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

Posted 17-Dec-17 0:44am

Member 12770648

Updated 12-Jan-21 20:47pm

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard Deeming · Answer 1 · 2017-12-18T09:10:00

At a guess, you already have a temporary table called #trial, which has different columns than the ones shown.

When you try to execute the batch, SQL Server tries to compile it using the existing table definition. When it finds that the columns don't match, it produces an error and doesn't execute the batch.

Try selecting and running just the DROP TABLE #trial line. Then you should be able to execute the rest of your query.

OriginalGriff · Answer 2 · 2017-12-17T02:17:00

Works for me:

SQL

create table #trial ( names varchar(10) ,
subject varchar(10) ,
marks varchar(10)
) 

insert into #trial values ('ama' , 'maths' ,'A20')
insert into #trial values ('kay' , 'maths' ,'A30')
insert into #trial values ('kay' , 'geog' ,'A40')
insert into #trial values ('joh' , 'maths' ,'A50')
insert into #trial values ('joh' , 'geog' ,'A60')
insert into #trial values ('joh' , 'physics' ,'A70')
insert into #trial values ('ros' , 'english' ,'A80')

select * from #trial
drop table #trial

Gives

names  subject       marks
ama    maths         A20
kay    maths         A30
kay    geog          A40
joh    maths         A50
joh    geog          A60
joh    physics       A70
ros    english       A80

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

2 solutions

Solution 2

Solution 1

Add your solution here

Preview 0