A very common question, I keep on getting is how to get column names for a particular column. Well, it is pretty straightforward and easy to do.
Well, in situations like this we should consider using the function STRING_ESCAPE() which works for JSON. Let us quickly discuss String Escape.
Earlier I wrote a blog post on Forwarded Records and Performance and lots of people liked the blog post. Here is you can read the blog post SQL SERVER – What is Forwarded Records and How to Fix Them?