MicroStrategy ONE

Decimal Separator（小数分隔符）

小数分隔符 VLDB 属性指定是否使用“.”或“，”作为小数分隔符。此属性适用于非英语环境下的数据库用逗号作为分隔符的情况。

(,) 作为小数分隔符（默认）

select a11.DEPARTMENT_NBR DEPARTMENT_NBR,
 a11.STORE_NBR STORE_NBR
into #ZZTIS00H5K4MQ000
from HARI_COST_STORE_DEP a11
group by a11.DEPARTMENT_NBR,
 a11.STORE_NBR
having sum(a11.COST_AMT) > 654.357

“，”作为小数点分隔符 

select a11.DEPARTMENT_NBR DEPARTMENT_NBR,
 a11.STORE_NBR STORE_NBR
into #ZZTIS00H5K5MQ000
from HARI_COST_STORE_DEP a11
group by a11.DEPARTMENT_NBR,
 a11.STORE_NBR
having sum(a11.COST_AMT) > 654,357