DECLARE @json NVARCHAR(MAX) = '

[

{ "id": 1, "name": "Alice" },

{ "id": 2, "name": "Bob" }

]';

SELECT *

FROM OPENJSON(@json)

WITH (

id INT,

name NVARCH

AR(100));