Browse by Tags

• iPod
• Performance
• SSIS
• T-SQL

• Multiple-Valued Parameters

  So I was doing some research on which is the best way to pass multiple-valued parameters into a stored procedure or user-defined function when I found some interesting results. I had always used a string-based user-defined function to parse a delimited Read More... Posted Monday, February 12, 2007 4:43 PM by Peter W. DeBetta | 19 Comments Filed under: T-SQL, XML, Performance

• XML Data Type Methods and SSIS Package Variables

  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... Posted Monday, December 18, 2006 2:31 PM by Peter W. DeBetta | 2 Comments Filed under: T-SQL, SSIS, XML

• iPod and iTunes - Parsing the XML Library

  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... Posted Tuesday, December 05, 2006 1:55 PM by Peter W. DeBetta | 7 Comments Filed under: T-SQL, XML, iPod Attachment(s): itunes xml for sqlblog.sql