SELECT directly from values
If you want to select multiple sets of values with no tables […]
Category: sql server
SqlBulkCopy in C#
For a bulk insert from .NET to SQL Server, you’ve got a […]
ArithAbort in ADO.NET
Don’t ask me to explain it, but setting ARITHABORT in 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 text to […]