SQL Tip: FOR XML (Create a comma separated list of values)

[edit: December 2019] This was originally posted to my internal (to Microsoft) blog on October 7, 2013 as part of a series I called 'SQL Tips' for coworkers and an email distribution list people could sign up to. I have left this as originally written but have updated formatting for my WordPress theme...and updated the … Continue reading SQL Tip: FOR XML (Create a comma separated list of values)

SQL Tip: The “query()” and “value()” methods (XML)

[edit: March 2019] This was originally posted to my internal (to Microsoft) blog on July 27, 2013 as part of a series I called 'SQL Tips' for coworkers and anyone else who was interested. You'll see that at the time I was relatively new to XQuery. Rather than update or fix this tip now that … Continue reading SQL Tip: The “query()” and “value()” methods (XML)