SQLServerPSModule icon indicating copy to clipboard operation
SQLServerPSModule copied to clipboard

PowerShell Write-SqlTableData Computed Column Error

Open van-thieu opened this issue 2 years ago • 1 comments

Cannot insert new data onto table when a computed column exists, returned below error:

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

van-thieu avatar Mar 16 '23 15:03 van-thieu

Hi @van-thieu - could you expedite my investigation by providing a simple repro? A script that would create the DB/Table and the actual .ps1 you are running would be fantastic. Thanks!

Matteo-T avatar Mar 23 '23 08:03 Matteo-T