Saturday 31 May 2014

Applying A Computed Column To SQL Server Table


There are many reasons as to why you would prefer to use a computed column and one of them is its ability to assign a field to hold a specific total for something.

While others prefer not to use it and carry on with their own preferences,    we can go ahead and play with it a bit and see how this can help us.

First, let's see what a computed column is. From MSDN, it says:

"A computed column is computed from an expression that can use other columns in the same table. The expression can be a noncomputed column name, constant, function, and any combination of these connected by one or more operators. The expression cannot be a subquery.'

Related Posts Plugin for WordPress, Blogger...