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…
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…