Support computed column on computed computed columns
Please add support of the creation of computed columns referencing other computed columns. Currently, you have to repeat the logic of computed column in multiple places. So it is potentially can create inconsistencies.
If it is challenging to resolve the order of calculation in the engine, you can introduce a new attribute "SOLVEORDER" which would be by default = 1. And If you want to reference a computed column in another computed column it would use SOLVEORDER = 2.
CREATE TABLE Tab
, b int
, c int
, d as (a+b) PERSISTED
, e as (d * c) PERSISTED, SOLVE_ORDER = 2