1. vbweb New Member

   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

   vbweb, Jul 15, 2004

   #2
2. satya Moderator

   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.

   satya, Jul 16, 2004

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in