MSSQL Power Function - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

MSSQL Power Function

MSSQL Power Function# Database - 数据库

B*L2010-04-20 07:04

1 楼

下面这个query（其中B是个长公式），column3 就是 column1 乘以 column2，
SQL server总是给我0.
SELECT
A
,POWER(cast(10 as dec(38,20)),B)
,A*POWER(cast(10 as dec(38,20)),B)
FROM TABLE_A
result:
8694 0.00000000003548134000 0.00000000000000000000
2103 0.00000000003981072000 0.00000000000000000000
对column3，我试过以下几种办法，都不行。
,CAST(A as dec(38,20))*POWER(cast(10 as dec(38,20)),B)
,CAST(A as dec(38,20))*CAST(A POWER(cast(10 as dec(38,20)),B) as dec(38,20))
,CAST(CAST(A as dec(38,20))*CAST(A POWER(cast(10 as dec(38,20)),

B*L2010-04-20 07:04

2 楼

Solved:
cast(A as float)*POWER(cast(10 as dec(38,20)),B)

【在 B*********L 的大作中提到】

: 下面这个query（其中B是个长公式），column3 就是 column1 乘以 column2，
: SQL server总是给我0.
: SELECT
: A
: ,POWER(cast(10 as dec(38,20)),B)
: ,A*POWER(cast(10 as dec(38,20)),B)
: FROM TABLE_A
: result:
: 8694 0.00000000003548134000 0.00000000000000000000
: 2103 0.00000000003981072000 0.00000000000000000000

j*n2010-04-20 07:04

3 楼

you probably want do the CAST(A as dec(38,20)) as well. Since converting to
float may give you some exceptional numbers. Just my 2 cents.

【在 B*********L 的大作中提到】

:
: Solved:
: cast(A as float)*POWER(cast(10 as dec(38,20)),B)

B*L2010-04-20 07:04

4 楼

Thanks.
I don't know why, but CAST(A as dec(38,20)) gives me 0.00000000000
Only float works.

to

【在 j*****n 的大作中提到】

: you probably want do the CAST(A as dec(38,20)) as well. Since converting to
: float may give you some exceptional numbers. Just my 2 cents.