Book a Demo

Author Topic: SQL Server Computed Columns  (Read 2522 times)

tprohas

  • EA User
  • **
  • Posts: 32
  • Karma: +0/-0
    • View Profile
SQL Server Computed Columns
« on: January 31, 2005, 06:25:11 pm »
Does anyone know if its possible to add computed columns to a database table for sql server? I'm trying to create ddl that looks like the following.

ALTER TABLE BuildItem
ADD TotalCostPrice AS UnitCostPrice * Quantity,

TotalSalePrice AS UnitSalePrice * Quantity