Tag Archives: T-SQL

JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger

Posted on April 15, 2026 by way0utwest

I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an example of why it can behave weirdly. This post looks at something you might not realize unless you remember this is an aggregate function. Another post … Continue reading →

Posted in Blog | Tagged , | Leave a comment

Finding the Next Sequence Value: #SQLNewBlogger

Posted on March 30, 2026 by way0utwest

I saw a question asking about the next sequence value and decided to try and answer it myself. I assumed this would be easy, and it was, but I used some AI help to make it very quick to get … Continue reading →

Posted in Blog | Tagged , , | 3 Comments

Finding and Updating Duplicate IDs: #SQLNewBlogger

Posted on March 18, 2026 by way0utwest

Finding duplicates was an interview question for me years ago, and I’ve never forgotten it. Recently I got asked how to easily do this and delete them, so I decided to write a couple of posts on the topic. This … Continue reading →

Posted in Blog | Tagged , , | Leave a comment

Identity Columns Can’t Be Updated: #SQLNewBlogger

Posted on February 25, 2026 by way0utwest

I’m not sure I knew identity column values could not be updated. I ran into this while trying to solve a problem recently and had to check the error I was getting. This post shows what happened. Another post for … Continue reading →

Posted in Blog | Tagged , , | 4 Comments