Insert Command error
I wanna write insert command in sql 2005. I have 10 Columns, some of them can be null. I use this command: Insert Into TableName Values(x,y) since the others can be null, I don't bring them in command. cause, number of null-able columns are different, I can't bring exact null values. but I've got this e开发者_高级运维rror:Column name or number of supplied values does not match table definition. what can I do?
1 - Accept some of the past answers to your questions.
2 - Supply which fields you are inserting. In a 5 column table, you can say
INSERT INTO Table (col2, col4)
VALUES (col2value, col4value)
精彩评论