本文介绍了一种使用T-SQL触发器实现跨表数据同步的方法。具体来说，当向ComponentTable表中插入记录时，如何自动地将drawingId和hardwareId这两个字段的数据同步到另一个表HardWareTable中。
向ComponentTable插入数据时,将drawingId 和hardwareId插入到表HardWareTable
CREATE TRIGGER InsertComponentTable
on ComponentTable
FOR INSERT
AS
begin
declare @tempDrawingId varchar(50), @tempHardwareId varchar(25)
select @tempDrawingId=drawingId from inserted
select @tempHardwareId=hardwareId from inserted
insert into HardWareTable (hardwareId,drawingId) values (@tempHardwareId,@tempDrawingId);
end
Go
CREATE TRIGGER InsertComponentTable
on ComponentTable
FOR INSERT
AS
begin
declare @tempDrawingId varchar(50), @tempHardwareId varchar(25)
select @tempDrawingId=drawingId from inserted
select @tempHardwareId=hardwareId from inserted
insert into HardWareTable (hardwareId,drawingId) values (@tempHardwareId,@tempDrawingId);
end
Go
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
