Page History: JSON Data in T-SQL - SQL Server

Compare Page Revisions

3 2 1 0 Current 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Thu, Oct 31, 2019, 11:45 AM

Overview¶

This article gives sample SQL for querying and parsing JSON data in SQL Server

Sample Data¶

The Before field looks like this

[{
    "Id": 392571,
    "CreatedOn": "2019-06-19T03: 00: 28"
}]

select top 10 Id ,a.Before ,IdBefore = json_value(a.Before, '$0."Id"') from dbo.AuditLog a