This is the big one,

declare @xml as xml

set @xml = '<value>0001-01-01T00:00:00</value>'

In 2005

@xml.value('xs:dateTime(value[1])', 'datetime') results in NULL

so passing in DateTime.MinValue from .net where MinValue represented null works quite nicely (although...