本文介绍了一个具体的SQL触发器实现案例，该触发器在订单成功时被激活，将订单产品信息同步到购买记录表中。通过使用T-SQL声明变量、获取插入数据及字符串拆分函数等技术手段，实现了高效的数据同步。
alter trigger T_DataAddTOBuyRecord ON
Fl_Order_Success for insert
as
begin
declare @OrderId varchar(50);declare @ProIds varchar(50);declare @UserId int;
--set @OrderId=(select OrderId from Inserted);set @ProIds=(select ProIds from Inserted);
select @OrderId=OrderId,@ProIds=ProIds,@UserId=UserId from Inserted;
insert into Fl_BuyRecord (OrderId,ProId,UserId)
select @OrderId,a,@UserId from dbo.f_split(@ProIds,',');
end
Fl_Order_Success for insert
as
begin
declare @OrderId varchar(50);declare @ProIds varchar(50);declare @UserId int;
--set @OrderId=(select OrderId from Inserted);set @ProIds=(select ProIds from Inserted);
select @OrderId=OrderId,@ProIds=ProIds,@UserId=UserId from Inserted;
insert into Fl_BuyRecord (OrderId,ProId,UserId)
select @OrderId,a,@UserId from dbo.f_split(@ProIds,',');
end
扫一扫
531
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
