Using XML to Pass Arrays as Parameters

One of the major issues when working within T-SQL is the lack of support for arrays. Enter XML, as this article discusses.

XML is one area inside SQL Server that I have not worked with to any great extent, however I do believe that it is a very powerful tool.

My alternative has been to pass in a comma delimited string and then use a user defined function to split that delimited string and place the results in a temporary table. The XML route seems to be a cleaner solution.

Posted by Douglas Reilly at 05:06 PM  Permalink