search

microsoft / SQLServerPSModule

This repo is the home of SQL Server PowerShell Module development.
MIT License
45 stars 1 forks source link

PowerShell Write-SqlTableData Computed Column Error #29

Open van-thieu opened 1 year ago

van-thieu commented 1 year ago

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.

Matteo-T commented 1 year ago

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!