bcp in 错误

最新推荐文章于 2018-04-21 22:17:51 发布

weixin_30270561

最新推荐文章于 2018-04-21 22:17:51 发布

阅读量422

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/sky100/archive/2009/03/25/1421113.html

版权

用bcp导入时，报如下错误：

Starting copy...
CTLIB Message: - L1/O2/S1/N24/1/0:
blk_rowxfer(): blk layer: internal BLK-Library error: No value or default value available and NULL not allowed. col = 6
CTLIB Message: - L1/O2/S1/N24/1/0:
blk_rowxfer(): blk layer: internal BLK-Library error: No value or default value available and NULL not allowed. col = 6
CTLIB Message: - L1/O2/S1/N24/1/0:
blk_rowxfer(): blk layer: internal BLK-Library error: No value or default value available and NULL not allowed. col = 6
CTLIB Message: - L1/O2/S1/N24/1/0:
blk_rowxfer(): blk layer: internal BLK-Library error: No value or default value available and NULL not allowed. col = 6
CTLIB Message: - L1/O2/S1/N24/1/0:
blk_rowxfer(): blk layer: internal BLK-Library error: No value or default value available and NULL not allowed. col = 6
CTLIB Message: - L1/O2/S1/N24/1/0:
blk_rowxfer(): blk layer: internal BLK-Library error: No value or default value available and NULL not allowed. col = 6
CTLIB Message: - L1/O2/S1/N24/1/0:
blk_rowxfer(): blk layer: internal BLK-Library error: No value or default value available and NULL not allowed. col = 6

bcp copy in failed

0 rows copied.
Clock Time (ms.): total = 125

存在原因：数据库中表的字段不能为空，并且没有默认值，但bcp里第6列有为空的值。

所以无法插入记录。

转载于:https://www.cnblogs.com/sky100/archive/2009/03/25/1421113.html