← Back to Posts

sqlserver select as JSON

👤 علی ذوالفقار 📅 1402/07/04 12:44:50 👁️ 294 views
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 to Posts