Replace Function Errors with “String or Binary Data will be truncated” While Using NVARCHAR(Max)
The other day I was working on a script to update a value inside of a long string that is stored in a database. While doing this my script threw…
Why you can’t add 1 millisecond to a DateTime in SQL
The other day I needed to do a data change to add milliseconds to date times just to prevent duplicates. I won’t go over the whole scenario but we needed…
How to use At Time Zone in SQL Server
How to convert a DateTime to a DATETIMEOFFSET offset using SQL server’s AT TIME ZONE function. Aahhh... dates and times in code.. aren't they always fun? I needed to migrate…