Computed columns vs computed in a trigger? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Computed columns vs computed in a trigger?

Hi, I was wondering if someone could explain how exactly computed columns work – does SQL Server effectively just recalculate the value whenever a row is inserted or updated? Are there any advantages updating the value in a trigger over a calculated column? (aside from the fact you can perform more complex calculations in a trigger) Cheers, ~ James
Refer to the books online for Computed Columns topic and this link for information. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.