Posted June 20, 2024Jun 20 The native JSON type allows JSON documents to be stored in a binary format. This binary format allows for efficient query processing and in-place modifications of JSON documents. The JSON aggregates - JSON_OBJECTAGG & JSON_ARRAYAGG enable easy aggregation of relational data into a JSON document. Learn more in this episode of Data Exposed with Anna Hoffman and Umachandar Jayachandran. Resources: JSON data type (preview) - SQL Server | Microsoft Learn JSON_OBJECTAGG (Transact-SQL) - SQL Server | Microsoft Learn JSON_ARRAYAGG (Transact-SQL) - SQL Server | Microsoft Learn View/share our latest episodes on Microsoft Learn and ! Continue reading...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.