All Questions
2
questions
0
votes
1
answer
1k
views
SQL Server JSON Transpose rows to columns
DECLARE @json NVARCHAR(MAX)
SET @json='{"name":"John","surname":"Doe","age":45,"skills":["SQL","C#","MVC"]}';
...
1
vote
1
answer
144
views
Parsing JSON with T-SQL
I'm looking to only select each value name and value in the JSON string and pivot into separate columns in SQL so that I can easily pass these into a powershell string to send to an external API
...