• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. SQL Server Tables and Databas... > Working with Computed Columns

Working with Computed Columns

With computed columns, you can create a column that is based on data in other columns. SQL Server automatically updates the computed column when the columns that it depends on are updated. An example is an extended total that you base on the product of the price and quantity columns. To create a computed column, simply enter the desired formula into the Formula property of the column (see Figure 5.11).

Figure 5.11. To create a computed column, simply enter the formula into the Formula property of the column.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint