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