关于[SQL Server JSON Diff. Checking for differences between JSON documents.]的摘要:
If you are working on any module or routine such as a procedure, function or batch that produces a result, then you will want to compare it with something that you’ve prepared earlier to make sure that it is the same. It is often necessary to compare objects, particularly when you are working on a routine that generates an object and you want to check that an improvement you’ve made is actually returned the same result. An XML or JSON document is the nearest we get to an object in SQL Server. This is probably as near as you’d want. Although this routine is designed to compare JSON documents, and takes them as input, it can be used for comparing any results.