Insert Error: Column name or number of supplied values does not match table definition

Question

Insert Error: Column name or number of supplied values does not match table definition

cao jiqing

SSC Enthusiast

Points: 159
More actions
June 19, 2005 at 7:56 pm

#164685

Hi,
I create a transactional replication,but always get following error message:
Insert Error: Column name or number of supplied values does not match table definition.(Source: SCHDBA\MATH (Data source); Error number: 213)
Help me!

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

sushila SSC-Dedicated Points: 35293 More actions · Answer 1

This happens only when the number of columns in the destination table does not match the number of columns in the source table - one way to eliminate this is to explicitly name all the columns that you are inserting into...eg:

insert into table(col1, col2, col3)

values(1, 2, 3)

**ASCII stupid question, get a stupid ANSI !!!**

cao jiqing SSC Enthusiast Points: 159 More actions · Answer 2

Yes,Thank sushila!

It's Ok after I corrected this kind "insert into ... " in sp.

ben stopforth Valued Member Points: 68 More actions · Answer 3

I am getting this error when the columns match and i am entering the data direct into the table, any ideas?

sushila SSC-Dedicated Points: 35293 More actions · Answer 4

Ben - when you say "entering data directly" I assume you're using EM - have you tried running the "insert into"..off QA ?!

**ASCII stupid question, get a stupid ANSI !!!**