Computed columns - Sql Server

Computed Columns allows you to set the value of a column based on other columns data

CREATE TABLE #PRICE
(
BASEPRICE DECIMAL(11,2),
TAXES DECIMAL(11,2),
SHIPPING DECIMAL(11,2),
TOTAL AS (BASEPRICE + TAXES + SHIPPING)
)

INSERT INTO #PRICE (
BASEPRICE,
TAXES,
SHIPPING
) VALUES (
/* BASEPRICE - DECIMAL(11,2) */ 50.00,
/* TAXES - DECIMAL(11,2) */ 2.80,
/* SHIPPING - DECIMAL(11,2) */ 5.00 )

INSERT INTO #PRICE (
BASEPRICE,
TAXES,
SHIPPING
) VALUES (
/* BASEPRICE - DECIMAL(11,2) */ 20.00,
/* TAXES - DECIMAL(11,2) */ 1.50,
/* SHIPPING - DECIMAL(11,2) */ 0.00 )

SELECT * FROM #PRICE

--DROP TABLE #PRICE