How to change JSON Column name in sql server 2016

user_221919 0
Viewed 14714

How can I change the column name "JSON_F52......" to Any(e.g. SalesOrder)

enter image description here

sql-server sql
2 Answers

i think the final result will not have anything with that name, it is a temporary name to store the result..

If you want the result in a variable The output of the FOR JSON clause is of type NVARCHAR(MAX), so you can assign it to any variable, as shown in the following example.

DECLARE @SalesOrder NVARCHAR(MAX) = (SELECT TOP 10 * FROM Sales.SalesOrderHeader FOR JSON AUTO)

Then select from @SalesOrder

If you want to store it in a file then check this link

user_56718070
Related