SQL* (1/23/2013)
What is the need of computed column if we can do the same thing in the query/application?Can anybody give me such scenario where we must use this Computed column only?
Lets take example of TAX table where
following are the column
Basic_salary
HRA_Exemption
SAving_80C
saving_80CCC
calulated_tax (computed column)
So whenever "Basic_salary ,HRA_Exemption,SAving_80C,saving_80CCC" gets populated the formula attached with caluated_tax column , will populated this column. NO application or query intervention required
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)