ArithAbort in ADO.NET
Don’t ask me to explain it, but setting ARITHABORT in SQL Server […]
Category: 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:
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 […]
Insert with output in SQL Server
This can be an alternative to things like SCOPE_IDENTITY() or @@IDENTITY. declare […]
Drop Database in SQL Server
If you’re working locally, building a new app from scratch, you might […]