SQL 2008 Series: SQL Computed columns
A computed column or a calculated column in Microsoft SQL server is computed from an expression that can use other columns in the same table.
The expression can be a column name, constant, function, and any combination of these connected by one or more operators.
The computed values are never stored in the tables.
They are actually computed everytime.
Free Business Intelligence Trainings at: http://www.creativecommit.com