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.
Post a Comment for "When The Computed Column Will Update?"