Tag Archives: T-SQL

I heard someone say recently that you can’t change a primary key value in a row. That’s not the case, so I decided to show a quick proof of that. Another post for me that is simple and hopefully serves … Continue reading →

There is a SET command in SQL Server that changes how much data is returned from some fields. This short post shows what I learned about the SET TEXTSIZE command. Another post for me that is simple and hopefully serves … Continue reading →

We recently published an article on CHOOSE at SQL Server Central. I thought it was a good intro, but as someone noted in the comments, how do you use CHOOSE? Do you have to hard code choices? This post shows … Continue reading →

This was an interesting thing I saw in a Question of the Day submission. I hadn’t thought about the issue, but apparently DATEADD truncates values rather than rounding them. I’m not sure why that is the case, but it is. … Continue reading →