Browse by Tags

• c#
• solution
• sql
• sqlxml
• visual studio

19 November 2008
Solution to the SQL Server 2008 with Visual Studio 2008 SP1 Install Exception: "SQL Server 2008 setup requires .NET Framework 3.5 to be installed"

You would have never guess this by the error message, but ""SQL Server 2008 setup requires .NET Framework 3.5 to be installed" when you have Visual Studio 2008 SP1 installed means that you need to install Windows Installer 4.5, which can be found here: Read More...

1 Comments

Filed under: solution, sql server 2008, visual studio

 

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