sqlbulkcopy引发以下异常 [英] sqlbulkcopy raises following exception

问题描述

Detail.Price列无法修改，因为它是计算列或是UNION运算符的结果？

The column "Detail.Price" cannot be modified because it is either a computed column or is the result of a UNION operator?

推荐答案

你不能在计算列中插入数据。请参阅此链接。 http://www.sql-server-helper.com/error -messages / msg-271.aspx

[ ^ ] http：// www。 sqlteam.com/forums/topic.asp?TOPIC_ID=179041 [ ^ ]

You can't insert data in a computed column. Please see this links.http://www.sql-server-helper.com/error-messages/msg-271.aspx
[^]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=179041[^]

错误非常明确：

无法修改InvoiceDetail.RefPrice列因为它是计算列或者是UNION运算符的结果



所以看看 dstodt ，以及您设置 RefPrice 列的位置，因为问题就在那里！错误消息应该给你一个线索...

The error is pretty explicit:
"The column "InvoiceDetail.RefPrice" cannot be modified because it is either a computed column or is the result of a UNION operator"

So look at dstodt, and where you set the RefPrice column, because the problem is there! The error message is supposed to give you a clue...

OriginalGriff754K我已经评论了该列但仍然存在错误

OriginalGriff754K I have commented that column but still the error persists

这篇关于sqlbulkcopy引发以下异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！