Developers can specify an expression for a computed column in Table Designer. A computed column expression can use data from other columns to calculate a value for the column to which it belongs. When developers working with SQL Server “Denali”, MS SQL Server 2008 R2 and MS SQL Server 2005 want to specify a computed column, they should follow the next steps:

C# 8.0 and .NET Core 3.0 – Modern Cross-Platform Development: Build applications with C#, .NET Core, Entity Framework Core, ASP.NET Core, and ML.NET using Visual Studio Code, 4th Edition
ASP.NET Core 3 and Angular 9: Full stack web development with .NET Core 3.1 and Angular 9, 3rd Edition
C# in Depth, 4th Edition

1. In Object Explorer, right-click the table with columns for which they want to specify a computed column and click Design (Modify in SP1 or earlier).

The table opens in Table Designer.

2. Select the column for which they want to specify a computed column formula.

3. In the Column Properties tab, expand the Computed Column Specification property.

4. In the (Formula) child property, type the expression for this column in the grid cell to the right. For example, ColumnOne * ColumnTwo.

5. Indicate whether the data is persisted by choosing Yes or No from the drop-down for the Is Persisted child property.

The new computed column specification is assigned to the column in Table Designer after developers click outside the grid cell or use the TAB key to move to another grid cell and changes are stored in the database when they save their changes in Table Designer.