sql server - Raising numbers to fractional powers in SQL -


i'm trying raise series of numbers fractional (1/5) power in ms sql, yet i'm getting 'domain error' when applying negative base.

this shouldn't problem since i'm raising odd-powered root. further, i'm able calculation in excel.

can comment on whether ms sql doesn't support raising negative powers fractional roots?

negative base raised fractional power result in complex number sql server not support.

you can raise negative base integer power:

select  power(-3, 3) 

or positive base fractional power:

select  power(9, 1.5) 

Comments