开发者

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)
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜