Just came across very interesting scenario where I had to consume JSON data in SQL Server. Yes I can write C#/VB.net code and load JSON to SQL Server and go from there but what if I have no expertise in…
If you ever tried to cast string to XML data type in SQL Server then you may encounter this error select cast(xmldata as XML) from XMLFiles Msg 9402, Level 16, State 1, Line 1 XML parsing: line 1, character 54,…