在SQL Server Management Studio中,我正在创建以下表:
CREATE TABLE Purchase
(
PurchaseID INT NOT NULL
FOREIGN KEY REFERENCES Product(ProductID) PRIMARY KEY,
TotalQuantity INT NOT NULL,
Price AS (PurchaseID.PRICE),
TotalPrice AS (TotalQuantity*Price),
SalesAssistantID INT NOT NULL
FOREIGN KEY REFERENCES SalesAssistant(SalesAssistantID),
CashierID INT NOT NULL
FOREIGN KEY REFERENCES Cashier(CashierID)
)
上面的代码仅代表我想要实现的目标(Price AS (PurchaseID.PRICE)
(,Price
应在指定PurchaseID
时创建,以便TotalCost
也可以自动运行,我无法解决此问题。怎么办?
PurchaseID int identity(1,1) Primary key
这使 purchaseID 成为主键,(1,1)
意味着它将从 1 开始并递增 1。