Tag Archives: T-SQL

I was working with a customer and discussing how to do error handling. This is a short post that looks at how you can start adding TRY.. CATCH blocks to your code. Another post for me that is simple and … Continue reading →

For years I’ve assumed I knew the string defaults, but I realized that’s not right. This post looks at what I learned. Another post for me that is simple and hopefully serves as an example for people trying to get … Continue reading →

I was working with a customer that was doing some error handling in procs and helped them do some error tracking. As we were working through things, I realized that some of functions working with errors operated differently than I … Continue reading →

I saw someone using DATETRUNC recently in some code and realized I hadn’t really looked at this function before. It’s one that was added in SQL Server 2022, though it’s been in other platforms for years. This post looks at … Continue reading →