在两个DB的table之间同步数据
CREATE TRIGGER ON_INSERT_PERSON
ON dbo.Person
AFTER INSERT
AS
BEGIN
INSERT Temp.dbo.Person select Name from inserted
END
GO
ON dbo.Person
AFTER INSERT
AS
BEGIN
INSERT Temp.dbo.Person select Name from inserted
END
GO
中间可以加入更复杂的逻辑,做到有选择的插入等等。