ArithAbort in ADO.NET
Don’t ask me to explain it, but setting ARITHABORT in SQL Server […]
Tag: sql server
SQL Server Error Handling
From the incredible website of Erland Sommarskog – Definitely a worthwhile read. […]
SQL Server Numbers table
Flatten in SQL Server
Convert UTC to local time in SQL Server
Thanks to this StackOverflow answer:
Catching SQL exceptions in .NET
Here’s one way of handling SQL errors from .NET: For expected errors, […]
SQL Dates Table
SQL Merge Insert/Update with output
Is string an integer in SQL Server
SQL Server 2008 doesn’t yet have the TRY_PARSE function, so safely converting text to […]
Insert with output in SQL Server
This can be an alternative to things like SCOPE_IDENTITY() or @@IDENTITY.