MySQL触发器更新SQL Server表 [英] MySQL trigger to update SQL Server table

问题描述

是否可以使用MySQL中的触发器来更新SQL Server中的表.情况就是这样.

Is it possible to update a table in SQL Server using a trigger in MySQL. The scenario is like this.

在MySQL中更新表时，为了同步某些字段，将在SQL Server中进行相应的更新.我知道使用SQL Server中的链接服务器可以实现相反的操作.

When a table is updated in MySQL, a corresponding update is to be done in SQL Server for the purpose of syncing certain fields. I understand that the reverse is possible using a linked server in SQL Server.

推荐答案

您可以编写

You can write a UDF function that would update data in the SQL Server. Then call this UDF from the trigger.

这篇关于MySQL触发器更新SQL Server表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！