Computed columns in Azure SQL Server 2016 time windows

Question

I am looking at creating temporary tables https://msdn.microsoft.com/en-us/library/mt604462.aspx in our database, but I cannot find a couple of tables that have computed columns.

The returned error message is pretty self-evident

"The calculated column is defined using a user-defined function that is not allowed with a table with a system version

but I was hoping there was a way to exclude or ignore columns from tracking?

I tried resetting the computed column by creating a history table and then adding the computed column back to the table, but that didn't work.

Any help is appreciated.

thank

Edit -
I could not find a way to ignore the columns from tracking, but we were able to reorganize the columns that used UDF, which allows us to use temporary tables.

Answer 1

I struggled with adding a computed column to an existing table with a system version. In case someone else with a similar problem lands here, I finally realized that the history table does not handle the column the same way. As a result, it looks like the IDENTITY column in the base table, but this will result in a regular INT field in the history table.

If you are trying to add a calculated column to the system version of the (temporary) table:

• First turn off system version control
• ""
• ( )

, history_table, . , - , , .

@pasquale-ceglie - , , , . , . , , , . ( ). , ping me, .

Answer 2

, , , .

,