次の方法で共有

JSON is Generally available in Azure Sql Database!

  • [アーティクル]

JSON functionalities are now generally available in Azure Sql Database! All functions that are available in SQL Server 2016 are also available in Azure Sql Database.

Azure Sql Database enables you to get values from JSON documents using JSON_VALUE function, modify values in JSON text using JSON_MODIFY function, transform JSON to table using OPENJSON function or format Sql query results as JSON text using FOR JSON clause:

SQL/JSON

You can also index JSON values using NONCLUSTERED or FullText Search indexes.

JSON is available in all service tiers (basic, standard, and premium) but only in new SQL Database V12. You can see quick  introduction here or more details in Getting Started page. you can also find code samples that JSON functions in Azure Sql Database on official Sql Server/Azure Sql Database GitHub repository.

Note that OPENJSON function requires database compatibility level 130. If all functions work except OPENJSON, you would need to set the latest compatibility level in database.

Comments

  • Anonymous
    September 12, 2016
    Any idea when we'll get SQL Notifications in Azure SQL?
  • Anonymous
    September 21, 2016
    does this also include Azure SQL DW?
  • Anonymous
    April 12, 2017
    The comment has been removed