Peter DeBetta's blog about programming in SQL Server using technologies such as T-SQL, .NET, CLR, C#, VB, Visual Studio, and SQL Server Management Studio.
December 2006 - Posts
-
I was going to comment on Adam's post " Medians, ROW_NUMBERs, and performance " (which was a follow-up to Aaron's post " Take the high road to middle ground ") and I realized that I needed to show some code and alas, comments are not so nice about formatting Read More...
|
-
This is a follow-up to a posting from several months ago ( Using XML Data Type Methods to query SSIS Packages ). I included a temp table (based on information I found in the Microsoft.SqlServer.Dts.Runtime.VarTypeConvert class's constructor) which gives Read More...
|
-
So I was trying to figure out a way to get my iTunes/iPod music library into SQL Server. Unfortunately, the XML in the library is not the easiest with which to work. Here is an abridged version of that XML: < plist version = " 1.0 " > < dict Read More...
|