34,593
社区成员
发帖
与我相关
我的任务
分享
CREATE TRIGGER Contract_Detail
ON ContractInfo
FOR INSERT
AS
DECLARE @Cid char(10),
@Pid char(10),
@Clid char(10),
@Cprice money,
@Csum int,
@Cfinish datetime,
@Cstate varchar(6)
BEGIN
INSERT INTO [Store].[dbo].[DetailInfo]([ContractId], [ProductId], [ClientId], [ProductPrice], [ProductSum], [ContractFinish])
SELECT @Cid=[ContractId],@Pid=PsT.ProductId,@Clid=[ClientId],@Csum=[ContractSum], @Cstate=[ContractState],@Cfinish=[ContractFinish]
FROM inserted
where [ContractState] = '完成'
end