Add wings in sql

07/23/2015 20:53 アルカード#1
I tried to add wings in sql and this is problem i get





Msg 213, Level 16, State 1, Line 5
Column name or number of supplied values does not match table definition.





here is code

07/23/2015 22:55 Xijezu#2
The query is build for a different ItemResource structure.

Let's assume I created a table with the following columns:
[id], [name]

I've got the following query:
Code:
INSERT INTO test_table VALUES (1, 'test')
This query assumes that there are only 2 columns in my table. The query runs successfully.

Now, assume I've got this query:
Code:
INSERT INTO test_table VALUES (1, 'test', 12341234)
If I try to insert this into the same table I had above it can't ant wont work, because there is 1 more value which "has no column".
This is the case in your query.
Your table has less columns than your query you're trying to insert.

You can try to update your query to the new structure, that'd be the only solution.