Public preview: JSON in Azure SQL Database

2016년 3월 30일 수요일

JSON functionalities are available in Azure SQL Database V12 (preview). You can use new JSON functionalities to integrate Azure SQL Database with other services that exchange data in the JSON format. With the new JSON functionalities, you can:
  • Read data from JSON text by using JSON_VALUE/JSON_QUERY functions.
  • Modify JSON text by using the JSON_MODIFY function.
  • Transform JSON text into a relational format by using the OPENJSON function - OPENJSON function requires database COMPATIBILITY_LEVEL = 130!
  • Easily query or import JSON data into tables.
  • Query relational and JSON data stored in any relational table.
  • Format the results of SQL queries as JSON text and send it to any service or framework that uses JSON (for example, JavaScript/jQuery components and AngularJS/ReactJS frameworks).
You don't need any special setup to start using JSON. If you have apps that are sending JSON text to SQL Server or if you use JSON text that is already stored in your tables, simply write a query that gets the values from your JSON documents. For more information, see our official documentation and blog posts.

무료 계정

지금 등록하여 $200 Azure 크레딧을 받으세요.

무료로 시작

Visual Studio

최대 $1800 연간 Azure 서비스를 구독자에게 제공

지금 활성화

시작

BizSpark 프로그램에 가입하고 무료 Azure 서비스를 이용하세요

자세한 정보