sqlserver select as JSON

علی ذوالفقار
1402/07/04 12:44:50 (264)
use ( FOR JSON ) clause to convert result to josn : 
    SELECT BANK , MABLAGH FROM TBL_VARIZ_BE_KHAZANEH FOR JSON AUTO 

give a name to result column : 
    SELECT ( SELECT BANK , MABLAGH FROM TBL_VARIZ_BE_KHAZANEH FOR JSON AUTO ) AS DATA 
Back