SQL Server JSON Diff. Checking for differences between JSON documents. - Simple Talk

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.