how can I store Json query in SQL?

Question

I have to write Json and I dont know how could i store that query in SQL Server my code is this:

DECLARE @JsonData AS NVARCHAR(MAX) = (SELECT  FID,  Ftype, Fcount, Datetype, Fregion
                                      FROM FoodSara_tbl
                                      FOR JSON AUTO)

and if I write SELECT ISJSON(@JsonData ) it returns 1

how can I store Json query in SQL?

PS: I dont't want write it in SP

Answer 1

DECLARE @JsonData AS NVARCHAR(MAX) = 
   CAST((SELECT  FID,  Ftype, Fcount, Datetype, Fregion
         FROM FoodSara_tbl
         FOR JSON AUTO) AS NVARCHAR(max));

Because a query returns a dataset !... You need to specify that the single value returned in the dataset must be casted in string...