如何在sql server中获取更新的列名

我有一个名为user的表，其中包含Colid，如UnitID，FactoryName，MonetaryLimit，Location，City等



我想做的是



用户更新信息后，我想跟踪用户更新的列。不是更新的行，而是更新的特定行中的确切列。



我创建了一个更新触发器，但它没有给出确切的结果。写查询



谢谢



Dreen

I have a table called user with colums like UnitID, FactoryName,MonetaryLimit,Location,City etc

What I wanted to do is

After a user Updates his information I wanted to track which are the columns that are updated by the user. Not the updated row but the exact columns in a particular row which are updated.

I have created an update trigger, but it not giving the exact result . Write query

thanks

Dreen