两个表，一个A表，一个B表 A表列为BookID, Price B表列为BookID, Number, TotalPrice 两表通过BookID连接，如何在SqlServer中设置自动使得TotalPrice=Price*Number
写个触发器就行了
CREATE TRIGGER TR_TotalPrice
ON B
FOR UPDATE, INSERT
AS
UPDATE B SET TotalProce = A.Price * B.Number
FROM A, B, inserted I
WHERE A.BookID = B.BookID AND A.BookID = I.BookID
