put Json just in one field in a new table in sql

Question

I have to write the code that create a table in just one field then put the out put of my Json into that table, but I don't know how could I put the out put my Json in just one field. here is my Json code:

SELECT *
FROM Food_tbl
FOR JSON AUTO

the output of the Json is like this:

[{"FID":1,"Fname":"cake","Fcount":5,"FDate":"2020-02-13","Fregion":"UK"},...]

output:

in new tabel that store in database like this:

|     JsonOutPut                                                                   |
|----------------------------------------------------------------------------------|
|   [{"FID":1,"Fname":"cake","Fcount":5,"FDate":"2020-02-13","Fregion":"UK"},...]  |

Answer 1

Finally I found my answer, here is my code:

DECLARE @OneRowJson NVARCHAR(MAX) = (SELECT * 
                                    FROM FoodSara_tbl
                                    FOR Json AUTO)
SELECT @OneRowJson OneRow INTO OneFieldJsonFood