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 ***@***.***> 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 <#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 iOS<https://aka.ms/o0ukef>

________________________________ From: Dmitriy Dyatchenko <notifications@github.com> Sent: Saturday, June 6, 2020 9:33:00 PM To: dyatchenko/ServiceBrokerListener <ServiceBrokerListener@noreply.github.com> Cc: arkgroup <arkgroup@hotmail.com>; Author <author@noreply.github.com> 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 ***@***.***> 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 <#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 GitHub<#68 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ABUGCX53NKGKWEJB4735UI3RVL35ZANCNFSM4NWAZ52A>.