Devin Manno 
May 17, 2016The XML datatype in SQL Server allows you to store, process and query XML rather easily. There are some caveats, however: You can not compare or order by an XML data type field in SQL Server Entity Framework does not support the XML data type, so your XML field will be converted to a string Continue reading →
Devin Manno March 3, 2014When performing calculations in T-SQL, I found myself having to deal with zeros in division operations. While zeros in the numerator pose no threat, denominators of zero will cause your query to blow up. In order to fix divide by zero errors, I began writing CASE statements. However, this got old very quickly. The stored Continue reading →
Devin Manno November 15, 2013If you need to import data from a Microsoft Access database to SQL Server, one simple way is to setup the Access file as a Linked Server. You can add the linked server using the SQL Server Management Studio GUI, or through T-SQL commands. Run the sp_addlinkedserver procedure to add a Linked Server. Follow that Continue reading →