sql server computed column

علی ذوالفقار
1400/10/14 08:05:46 (216)
add computed column to speed up the views
ALTER TABLE Table_Name
    ADD Column_Name 
    AS CAST(JSON_VALUE(JSON_DATA_COLUMN,'$.json.path.to.data') AS INT ) 
    PERSISTED
persisted option will force this commuted column to save physical and recalculate after change
Back