By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
DECLARE @json NVARCHAR(MAX)
SET @json='{"name":"John","surname":"Doe","age":45,"skills":["SQL","C#","MVC"]}';
select *
from openjson(@json) with (
name nvarchar(max),
surname nvarchar(max),
age int
);
| name | surname | age |
|---|---|---|
| John | Doe | 45 |