产品表
id name price quantity total
1 food 50 1 50
2 drink 20 2 40
3 dress 100 3 300
如何声明一个包含两个列的乘积的表格?
我有以下代码:
CREATE TABLE [dbo].[Orders] (
[Id] INT IDENTITY (1, 1) NOT NULL,
[ProductName] NCHAR (70) NULL,
[Price] INT NULL,
[Quantity] INT NULL,
[Total] INT NULL,
PRIMARY KEY CLUSTERED ([Id] ASC)
);
total
吗?或许在你的 SQL 查询或者视图中计算更合适。如果你确实需要一个“计算列”,可以这样声明:[Total] INT AS (Price * Quantity)
。 - sgeddesAS
时,[Total] INT AS (Price * Quantity)
会出现错误。 - nAPLALTER TABLE [Orders] ADD TOT INT AS Price * Quantity;
:( - nAPL