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