Browse by Tags

• ADO.NET

• InvalidOperation? I was only trying to open a connection...

  I stumbled across a little ADO.NET gotcha the other day... By and large, ADO.NET's SQL client library presents a good, consistent exception interface when something goes wrong: errors and warnings are reported as instances of SqlException and there is... Posted Dec 12 2006, 06:29 PM by chrisdi with | with 1 comment(s) Filed under: SQL Server, ADO.NET

• SQL Server: The effect of collation on CHECKSUM

  Diagnosing a bug in a SQL Server stored procedure recently I unearthed an interesting ‘feature’ of the CHECKSUM function which I couldn't find documented elsewhere. The stored procedure received some data as Unicode string arguments, and after some validation... Posted Oct 31 2006, 11:45 AM by chrisdi with | with 4 comment(s) Filed under: SQL Server