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 linkhttp://www.sqlteam.com/item.asp?ItemID=348 for information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>