POWER(@variable,2) SQL Server
I have a number like 8.32596e+010
when I try to do POWER(@variable,2)
it says there is a f开发者_开发问答loating point error, How do you fix this??
The following T-SQL works for me, in SQL Server 2008:
declare @x float
declare @y float
set @x = 8.32596e+010
set @y = POWER(@x,2)
print @y
6.93216e+021
Check that you're declaring all variables as floats (or floating-point types).
精彩评论