Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gagani
Posting Yak Master
112 Posts |
 Posted - 2011-11-18 : 17:26:35
|
| I added few columns to the table and changed the stored procedure(which does update) to accomodate the extra column fields. Then I am getting the following error:"Insert error: column name or number of supplied values does not match the table definition"I am very sure of the count of values and column names in stored procedure. could anyone please help me. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-11-18 : 22:28:28
|
| “It ain't what you don't know that gets you into trouble. It's what you know for sure that just ain't so.” -- Mark TwainCheck again. The error message is pretty specific.If you can't spot it, post the table definition and the stored procedure code and we'll help ya nail it. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-19 : 01:40:38
|
quote:
Originally posted by gagani
I added few columns to the table and changed the stored procedure(which does update) to accomodate the extra column fields. Then I am getting the following error:"Insert error: column name or number of supplied values does not match the table definition"I am very sure of the count of values and column names in stored procedure. could anyone please help me.
I dont think the error is in updateI think you're having some insert either to temporary table or something in the procedure where you've not added the new column(s)------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Insert Error: