Powershell SqlServer Modules Write-SqlTableData Computed Column

Question

Let's assume a table has a computed column, using the SqlServer PowerShell module command Write-SqlTableData, how does one manage to insert data onto the table if a computed column exists? Thanks!

I'm running into and error:
The column "A" cannot be modified because it is either a computed column or is the result of a UNION operator.

Answer 1

@Van Thieu :

You will need to specify the columns you want to insert values into. Please find the below mentioned sample SQL script where InventoryValue is the computed field.

Reference: https://learn.microsoft.com/en-us/sql/relational-databases/tables/specify-computed-columns-in-a-table?view=sql-server-ver16

CREATE TABLE dbo.Products
   (
      ProductID int IDENTITY (1,1) NOT NULL
      , QtyAvailable smallint     
      , InventoryValue AS QtyAvailable * UnitPrice
	  , UnitPrice money
    );

INSERT INTO dbo.Products (QtyAvailable, UnitPrice) VALUES (25, 2.00), (10, 1.5);

select * from dbo.Products

Answer 2

how does one manage to insert data onto the table if a computed column exists?

By not inserting into/addressing the computed column; by the error message you try to do so; that's your failure here.