Is it just me, or is this just a little bit, well, crap?

Minor quibble - the question asks about UPDATED_COLUMNS but the function is actually COLUMNS_UPDATED.

Simple...

Thanks to all.  I adapted Steve's code and it seems to work correctly.  Now all I have to do is figure out how to use it in C#/LINQ!

Also, I've noticed that there's an error in the data, rectified by this script:

UPDATE

[People].[Person]

SET

LineManagerId =209

WHERE

(Id = 19);

That's me told. My 6,000 points arise mainly from answering QotD, but apologies for supplying everything in the wrong order and in the wrong format.  I'll try to do better...

• This reply was modified 4 months, 2 weeks ago by edwardwill.

Here's some data inexpertly obfuscated.

@Kevin77 - the short answer is that I use CoPilot to do the basic heavy lifting - I don't just tell it to write the unit tests and then assume...

As they say in my part of the world (Gloucestershire) - that's the badger.

My employer (a moderately large software house in the UK, employing ~350-400 people) not only pays for GitHub Copilot, it also encourages us to use it.  It's good for grunt...

The DDL for the table was missing the [total] column.

The DDL for the table was missing the [total] column.

I'm not a DBA but a C# developer who has used SQL Server since V7. In my normal line of work, I've recently written a number of classes and then...

Thank you to Tonie and Jeffrey for explaining this to me ... I was completely wrong!

Assuming that your table contained only 1 row as specified, I don't think the answer is correct.  I spun up a nonce table with exactly that data and the query...