doumouyi4039 2019-06-10 15:10
浏览 85

Json可以调用SQL格式(货币)查询吗?

I'm making a datatable, calling my data(JSON) by ajax, so i can't format my columns manually so instead, formatted directly to currency in SQL 2012

The problem is, when i try to use the Json with the concat in my datatable, the format disapeares. Is there a way to do this?

i tried:

FORMAT(bd.dbo.table.column, 'C', 'en-us') AS 'R1',

AND

concat('$',SUM(bd.dbo.table.column)) as R2

both work just fine in SQL but when i try them in Postman only the concat gives me the currency symbol.

edit**

this is how i make the call

my json gives me this

{"data":[{"col1":"0106","col2":"5","col3":4,"col4":3,"PENDIENTE":22029.328,"PENDIENTE2":"$22,029.33","PENDIENTE3":"$22029.3"}]}

this is my query

SELECT 
    database.dbo.table1.col1,
    database.dbo.table1.col2,
    database.dbo.table2.col3,
    database.dbo.table1.col4,

    sum(database.dbo.table2.colMoney*
        database.dbo.table2.colMoney2) as PENDIENTE,

    FORMAT(sum(database.dbo.table2.colMoney*
        database.dbo.table2.colMoney2), 'C', 'en-us') AS PENDIENTE2,

    concat('$',sum(database.dbo.table2.colMoney*
        database.dbo.table2.colMoney2)) as PENDIENTE3
FROM
    database.dbo.table1,
    database.dbo.table2,
    database.dbo.table3
WHERE
    database.dbo.table1.ID = 
    database.dbo.table2.ID
AND
    database.dbo.table2.colMoney > 0 
GROUP BY    
    database.dbo.table1.col1,
    database.dbo.table1.col2,
    database.dbo.table2.col3,
    database.dbo.table1.col4

the thing is in the table neither currency simbol nor format will be shown

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 关于#hadoop#的问题
    • ¥15 (标签-Python|关键词-socket)
    • ¥15 keil里为什么main.c定义的函数在it.c调用不了
    • ¥50 切换TabTip键盘的输入法
    • ¥15 可否在不同线程中调用封装数据库操作的类
    • ¥15 微带串馈天线阵列每个阵元宽度计算
    • ¥15 keil的map文件中Image component sizes各项意思
    • ¥20 求个正点原子stm32f407开发版的贪吃蛇游戏
    • ¥15 划分vlan后,链路不通了?
    • ¥20 求各位懂行的人,注册表能不能看到usb使用得具体信息,干了什么,传输了什么数据