Skip to content
Home ยป Using Computed Columns in SQL Server with Persisted Values

Using Computed Columns in SQL Server with Persisted Values

SQL Server Computed Columns

A computed column is a virtual column which is used to add a new column to a table with the value derived from the values of other columns in the same table.

Computed column is not physically stored in the table, unless column is marked PERSISTED and it is persisted only if its expression is deterministic.

Loading