Tag Archives: T-SQL

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 , , | 2 Comments

RANK() vs DENSE_RANK(): #SQLNewBlogger

Posted on February 18, 2026 by way0utwest

I haven’t done one of these in awhile, but I saw an article recently about this and decided to explain it to myself, but in a slightly different way. You’ll see how I checked on RANK() vs DENSE_RANK() below. Another … Continue reading →

Posted in Blog | Tagged , , , | Leave a comment

Aging Code for T-SQL Tuesday #195

Posted on February 10, 2026 by way0utwest

It’s that time of the month again, with T-SQL Tuesday coming along. I managed to not forget about this and checked with the host. He had an issue, but fortunately I got a friend to step up. This month Pat … Continue reading →

Posted in Blog | Tagged , | 1 Comment

Learning from Mistakes: T-SQL Tuesday #194

Posted on January 20, 2026 by way0utwest

We’re a week late, once again my fault. I was still coming out of the holidays and forgot to check on my host. Luckily, Louis Davidson (who did have Feb) agreed to go early. He has a nice invite, and … Continue reading →

Posted in Blog | Tagged , , | 1 Comment