How to insert a json value to a column for each row of data in SQL?
The Json is formed by the combination of the column values of each row
I want to insert a JSON string like to the column 'JSONDoc'
({"PartitionKey":"A","SourceType":"MDD","SourceKey":"DA44DF8B-57C2-46C1-B1A2-92EF0620DB10$7AA49B70-9001-4412-B263-1342DAF215E7","OrganizationOwningAttID":260029,"OrganizationGUID":"DA44DF8B-57C2-46C1-B1A2-92EF0620DB10","OrganizationID":380417,"OrganizationName":"abc"})
which is combination of the values in the table for each row
OPENJSON
and aJOIN
? - Larnu