When will the calculated column be updated?

Question

I computed a column in a table called "Requirement", and the column definition calls one scalar function.

I created 10,000 statements, so when I select the 10,000 claims that the calculated column will be updated, will 10,000 rows be inserted that insert themselves into the calculated column?

Please update me

Thank you in advance

Answer 1

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

If none of these conditions is true, then nothing is stored and calculated at runtime. Otherwise, it is automatically updated when the underlying data changes.

Answer 2

The calculated column calculates its value when executing the SELECT command, which includes the column, assuming that the value of the calculated column is not PERSISTED .