SQL Tip: Unicode/Non-Unicode & Implicit Conversion

[edit: January 2020] This was originally posted to my internal (to Microsoft) blog on March 11, 2013 as part of a series I called 'SQL Tips' for coworkers based on an email distribution list I sent out before the internal blog. I have left this as originally written (where possible) and updated the formatting for … Continue reading SQL Tip: Unicode/Non-Unicode & Implicit Conversion

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)