insert语句的批量插入，在线等！！！！

[hang51]

string sqlStr = "INSERT ClientGoodsInfo (kindID,goodsID,goodsBarcode,departID,goodsName,goodsKind,mnemonicCode,packagCoef,goodsPackaging,goodsUnit,";
sqlStr += "priceIncludeTax,priceWithoutTax,goodsSendCenter,sellPrice,taxRate,goodsColor,interestRate,packBarcode,packPrice,packPackag,packUnit,packCoefficient,supplierID,supplierName,isWeighing.";
sqlStr += "isSeasonal,saleState,reasonableStore,storeUpperLimit,storeFloorLimit,isFormal,priceGrade,defaultStock,tryDate,registerDate,deliverMode,";
sqlStr += "madeArea,specialPrice,memberPrice,manageMode,isDiscount,standard,isScore,cupboardID,cupboardName)SELECT * FROM GoodsInfo WHERE kindID='" + TextBox1.Text + "'";
其中GoodsInfo表比ClientGoodsInfo表少一个kindID字段，应该怎么解决？

[dawugui]

kindID你想如何解决?
赋NULL,'',0?

SELECT null as kindID , * FROM GoodsInfo
SELECT 0 as kindID , * FROM GoodsInfo
SELECT '' as kindID , * FROM GoodsInfo

[zhuyx808]

kindID字段 是 怎么来的 ，自动增长还是别的什么值

[pyguang]

表少一个kindID字段,就不要加那个字段就行啦

[hang51]

补充：：
是把表GoodsInfo表中的一条记录添加到ClientGoodsInfo表
而GoodsInfo表比另一个表少一个字段。