2022-03-312022-05-07.net, sql server ArithAbort in ADO.NET Don’t ask me to explain it, but setting ARITHABORT in SQL Server […]
2022-01-282022-05-08sql server SQL Server Error Handling From the incredible website of Erland Sommarskog – Definitely a worthwhile read. […]
2021-08-182022-05-10sql server Convert UTC to local time in SQL Server Thanks to this StackOverflow answer:
2021-08-182022-05-12.net Catching SQL exceptions in .NET Here’s one way of handling SQL errors from .NET: For expected errors, […]
2021-08-112022-05-24sql server Is string an integer in SQL Server SQL Server 2008 doesn’t yet have the TRY_PARSE function, so safely converting text to […]
2021-08-112022-05-24sql server Insert with output in SQL Server This can be an alternative to things like SCOPE_IDENTITY() or @@IDENTITY.