JSON in Microsoft SQL Server: A Comprehensive Guide

  • Comments posted to this topic are about the item JSON in Microsoft SQL Server: A Comprehensive Guide

    Ankush Rastogi

    "Turning data into insights, one query at a time."

      [*] Database Enthusiast
      [*] SQL Server Specialist
      [*] Performance Tuning Expert

    LinkedIn | GitHub

    Got a SQL question? Feel free to ask!SELECT 'Have a great day!' AS Greeting;
  • This is a good round-up of what is possible with JSON and SQL Server. Well done on putting it together.

    My one non-JSON comment would be regarding the following:

    Always implement proper error handling when working with JSON data:

    While this is, of course, sound advice, it is followed by a code fragment where the CATCH block contains a SELECT of the errors occurring. Selecting errors in a CATCH block is not good practice, instead, use should be made of RAISERROR or THROW to make sure any errors do not get missed.

     

     


Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply