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-112022-01-16sql server Is string an integer in SQL Server SQL Server 2008 doesn’t yet have the TRY_PARSE function, so safely converting […]
2021-08-112022-01-16sql server Insert with output in SQL Server This can be an alternative to things like SCOPE_IDENTITY() or @@IDENTITY. declare […]
2021-08-112022-01-16sql server Drop Database in SQL Server If you’re working locally, building a new app from scratch, you might […]