Skip to content Skip to sidebar Skip to footer

When The Computed Column Will Update?

I have computed column in table called 'Claim' and definition of column is calling one scalar function. I created a 10000 claims so when i select those 10000 claims the computed c

Solution 1:

It depends if the computed column is marked as persisted or is indexed.

If neither of these conditions are true then nothing is stored and it is calculated at runtime. Otherwise it is automatcally updated when the underlying data changes.

Solution 2:

The computed column computes its value when you execute a SELECT command that includes the column, assuming that the computed column's value is not PERSISTED.

Post a Comment for "When The Computed Column Will Update?"