updated column

[arkgroup]

I am using SqlDependancyEx and get row data back with row that has been updated. Is there a way to find which column has been updated?

[dyatchenko]

Hello,

Unfortunately, it isn’t available in current implementation. However, it is possible to implement using UPDATE() function. https://www.mssqltips.com/sqlservertip/6076/how-to-find-updated-column-in-sql-server-trigger/

Thanks, Dmitrii

On Sat, 6 Jun 2020 at 07:07, arkgroup [email protected] wrote:

I am using SqlDependancyEx and get row data back with row that has been updated. Is there a way to find which column has been updated?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/dyatchenko/ServiceBrokerListener/issues/68, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACNTMP6NXRGJKRQST7IRIBTRVJERFANCNFSM4NWAZ52A .

-- Best Regards, Dmitrii Diatchenko Phone: +1 (425) 208-5469 Skype: dyatchenkodv [image: Dmitriy Dyatchenko] http://linkedin.com/in/dyatchenko

[arkgroup]

Thanks,

Please let me know if you include that in your code.

Regards,

Arkady

Get Outlook for iOShttps://aka.ms/o0ukef

---

From: Dmitriy Dyatchenko [email protected] Sent: Saturday, June 6, 2020 9:33:00 PM To: dyatchenko/ServiceBrokerListener [email protected] Cc: arkgroup [email protected]; Author [email protected] Subject: Re: [dyatchenko/ServiceBrokerListener] updated column (#68)

Hello,

Unfortunately, it isn’t available in current implementation. However, it is possible to implement using UPDATE() function. https://www.mssqltips.com/sqlservertip/6076/how-to-find-updated-column-in-sql-server-trigger/

Thanks, Dmitrii

On Sat, 6 Jun 2020 at 07:07, arkgroup [email protected] wrote:

I am using SqlDependancyEx and get row data back with row that has been updated. Is there a way to find which column has been updated?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/dyatchenko/ServiceBrokerListener/issues/68, or unsubscribe https://github.com/notifications/unsubscribe-auth/ACNTMP6NXRGJKRQST7IRIBTRVJERFANCNFSM4NWAZ52A .

-- Best Regards, Dmitrii Diatchenko Phone: +1 (425) 208-5469 Skype: dyatchenkodv [image: Dmitriy Dyatchenko] http://linkedin.com/in/dyatchenko

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/dyatchenko/ServiceBrokerListener/issues/68#issuecomment-640146907, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ABUGCX53NKGKWEJB4735UI3RVL35ZANCNFSM4NWAZ52A.