Understanding the concept of SARGable expressions can dramatically help you speed up query performance. Here’s how:
scalar
Converting JSON data to XML using a T-SQL function
Depending on your line of work, you may some time stumble over JSON data. JSON is a data format specifically designed to work well with Javascripts on web pages, so it’s fairly common in web service applications. If you’ve managed to land JSON data on your server and need to convert it to XML, here’s an idea how to.
sqlsunday.com 