Complex Computed Columns

You can have computed columns in SQL Server. This means you can create an user - defined function in SQL then you can create a column that will store data of that defined type. If you define a function that does A * B where A and B are columns, you can have a 3rd column of type A * B that will store the result of A * B.

Here's the article with code samples:

Read full article here.

IT Readings, Software Articles, SQL