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 |
|
kumarich1
Yak Posting Veteran
99 Posts |
 Posted - 2009-09-11 : 11:00:14
|
| After upgrading sql 2000 to sql 2005 and flagged compatibility to 90. I am getting below error for a simple update statement.update Testset name = 'ABC'where employee like '%ne' and project = 'PP'Error:Msg 213, Level 16, State 7, Procedure sp_who, Line 42 Insert Error: Column name or number of supplied values does not match table definition. |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2009-09-11 : 13:26:38
|
| check collation |
 |
|
|
kumarich1
Yak Posting Veteran
99 Posts |
Posted - 2009-09-11 : 13:53:48
|
| collation is same on all columns ,tables and databases |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
shah429
Yak Posting Veteran
52 Posts |
Posted - 2009-09-12 : 16:56:42
|
| Could you please post the table definition? I believe it has something to do with the data type of the column you are trying to insert value into. |
|
|
|
|
|
|
After upgrade