| Author |
 Topic  |
|
|
SherinEliz
Starting Member
5 Posts |
 Posted - 09/16/2006 : 02:04:57
|
i have to calculate
power(2,32) in SQL Server Enterprise Manager.
here 32 is obtained through a series of calculations. no problem there. Error is in calculating power.
I am getting the foll error
Arithmetic overflow error for type int value = 4294927696.00000000
i tried convert(bigint,power(2,32)) but no use since conversion will anyway take place only after power is calculated which again gives the same error. |
|
|
khtan
In (Som, Ni, Yak)
Singapore
16745 Posts |
Posted - 09/16/2006 : 04:25:03
|
try power(2.0, 32.0)
KH
|
 |
|
|
Kristen
Test
United Kingdom
22191 Posts |
Posted - 09/16/2006 : 04:29:50
|
POWER(CONVERT(bigint, 2), 32)
should do the trick.
Kristen |
|
|
|
madhivanan
Premature Yak Congratulator
India
22460 Posts |
Posted - 09/16/2006 : 08:20:52
|
>>convert(bigint,power(2,32))
Note that convertion will happen only after powering the number
Madhivanan
Failing to plan is Planning to fail |
|
|
| |
Topic |
|
Arithmetic overflow error for type int
