Keyword PERSISTED in SQL

PERSISTED specifies that the SQLServer database engine will physically store computing values in the table, and update these computing values when any other column on which the calculation column depends is updated. Marking a computed column as PERSISTED allows you to create an index for a deterministic but inaccurate computed column. For more information, see create an index for a calculated column. Used

PERSISTED specifies that the SQL Server database engine physically stores computing values in the table, and updates these computing values when any other column on which the calculation column depends is updated. Marking a computed column as PERSISTED allows you to create an index for a deterministic but inaccurate computed column. For more information, see create an index for a calculated column. Used

PERSISTED
The specified SQL Server database engine will store the computing values in the table physically, and the Hong Kong Server will also be rented. These computing values will be updated when any other column on which the calculation column depends is updated. Marking a computed column as PERSISTED allows you to create an index for a deterministic but inaccurate computed column. For more information, see create an index for a calculated column. All calculation columns used as partition bases for partitioned tables must be explicitly marked as PERSISTED. When PERSISTED is specified, computed_column_expression must be deterministic.

Create table orders (orderid, price, quantity, orderdate, total as price * quantity, total2 as Price * quantity persisted, shipedate as dateadd (day, 7, orderdate), website Space