This is the last and the final article in the series which discusses on the native JSON support in SQL 2016.Previously I had blogged on how JSON documents can be generated from relational data using FOR JSON construct here http://visakhm.blogspot.ae/2016/06/whats-new-in-sql-2016-native-json.html…
Whats New in SQL 2016 – Native JSON Function Support – Parsing JSON Document to Shred Relational Data
Previously I had blogged about the native support for JSON in SQL 2016 and the ability to generate JSON documents from relational data using FOR JSON syntax here .This blog is next in the series on JSON support and explains…
How to solve OPENQUERY MySQL Update Issue Using ODBC DSN
This blog explains an issue you’re likely to face while executing a remote UPDATE query against a MySQL server over a linked server connection using ODBC DSN based connectionstring Scenario Recently I was working in a project where I required…