Browse by Tags

• c#
• sqlxml

15 August 2008
New SQL Server Date DataTypes: Date, Time, DateTime2 & DateTimeOffset

Great video on the new Date DataTypes in in Sql T-SQL Enhancements and Date/Time SQL Server 2008 introduces new date and time data types: DATE – a date only type; TIME – a time only type; DATETIMEOFFSET – a timezone-aware datetime type; DATETIME2 – a Read More...

3 Comments

Filed under: sql, sql server 2008

 

30 January 2007
How to convert XmlDocument to XmlReader for SqlXml data type.

The SqlXml datatype constructor only accepts a Stream or XmlReader, if you have an XmlDocument in memory (go with stream if you have it) then you can easily convert to a SqlXml compatible stream with the XmlNodeReader class. XmlNodeReader implements IDisposable, Read More...

9 Comments

Filed under: c#, sql, sql server 2008, sqlxml