Home
%3CLINGO-SUB%20id%3D%22lingo-sub-386113%22%20slang%3D%22en-US%22%3EJSON%20is%20Generally%20available%20in%20Azure%20Sql%20Database!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-386113%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3EFirst%20published%20on%20MSDN%20on%20Sep%2005%2C%202016%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%20JSON%20functionalities%20are%20now%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fblog%2Fjson-support-is-generally-available-in-azure-sql-database%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20generally%20available%20in%20Azure%20Sql%20Database%20%3C%2FA%3E%20!%20All%20functions%20that%20are%20available%20in%20SQL%20Server%202016%20are%20also%20available%20in%20Azure%20Sql%20Database.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Azure%20Sql%20Database%20enables%20you%20to%20get%20values%20from%20JSON%20documents%20using%20JSON_VALUE%20function%2C%20modify%20values%20in%20JSON%20text%20using%20JSON_MODIFY%20function%2C%20transform%20JSON%20to%20table%20using%20OPENJSON%20function%20or%20format%20Sql%20query%20results%20as%26nbsp%3BJSON%20text%20using%20FOR%20JSON%20clause%3A%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F98954iB3B5051BE6AA1346%22%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20You%20can%20also%20index%20JSON%20values%20using%20%3CA%20href%3D%22https%3A%2F%2Fblogs.msdn.microsoft.com%2Fsqlserverstorageengine%2F2015%2F12%2F21%2Findexing-data-in-json-product-catalogs%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20NONCLUSTERED%20or%20FullText%20Search%20indexes%20%3C%2FA%3E%20.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20JSON%20is%20available%20in%20all%20service%20tiers%20(basic%2C%20standard%2C%20and%20premium)%20but%20only%20in%20new%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fdocumentation%2Farticles%2Fsql-database-v12-whats-new%2F%22%20title%3D%22%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20SQL%20Database%20V12%20%3C%2FA%3E%20.%20You%20can%20see%20quick%20%26nbsp%3Bintroduction%20here%20or%20more%20details%20in%20%3CA%20href%3D%22https%3A%2F%2Fazure.microsoft.com%2Fen-us%2Fdocumentation%2Farticles%2Fsql-database-json-features%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20Getting%20Started%20%3C%2FA%3E%20page.%20you%20can%20also%20find%20code%20samples%20that%20JSON%20functions%20in%20Azure%20Sql%20Database%20on%20official%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FMicrosoft%2Fsql-server-samples%2Ftree%2Fmaster%2Fsamples%2Ffeatures%2Fjson%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3E%20Sql%20Server%2FAzure%20Sql%20Database%20GitHub%20repository%20%3C%2FA%3E%20.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Note%20that%26nbsp%3BOPENJSON%20function%20requires%20%3CSTRONG%3E%20database%20compatibility%20level%20130%20%3C%2FSTRONG%3E%20.%20If%20all%20functions%20work%20except%20OPENJSON%2C%20you%20would%20need%20to%20set%20the%20latest%20compatibility%20level%20in%20database.%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-386113%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20Sep%2005%2C%202016%20JSON%20functionalities%20are%20now%20generally%20available%20in%20Azure%20Sql%20Database!%20All%20functions%20that%20are%20available%20in%20SQL%20Server%202016%20are%20also%20available%20in%20Azure%20Sql%20Database.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-386113%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESQLServerStorageEngine%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Microsoft
First published on MSDN on Sep 05, 2016
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:



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.