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 linkhttp://www.sqlteam.com/item.asp?ItemID=348 for information. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.