Using the POWER Function

Need raise a number to a power? You need the POWER function! Easy to use and intuitive, at least with positive powers. Need to raise a number to a negative power? Watch the video so that you understand that the answer you get may not be the one you expect - but we'll show you how to get it right!

Andy Warren is a software trainer focusing on SQL Server, a member of the PASS Board of Directors, and a principal in this site - SQLShare.com.

Will Casey on 11/29/2010

nice to know

kalapala baburao on 11/29/2010

ok

Jack Pines on 11/29/2010

I did not know about the decimal place limitation. How does that affect calculations on database fields such as MONEY, DECIMAL, and FLOAT?

Tahir A. Syed on 11/29/2010

Simple & interesting! Thanks, Tahir

Lee Linares on 11/29/2010

Excellent information about the use of negatives.

Nilesh on 11/29/2010

fine

Jamshid Nouri on 11/29/2010

short and excellent

Derek on 11/29/2010

Nice video, but I doubt I will ever use this

Al on 11/29/2010

Cool vid, thanks much

Steve Culshaw on 11/30/2010

Good nugget, especially on watching out for the edge conditions

Tina on 11/30/2010

Thank you!

ranu on 11/30/2010

learned something new

Don Weigend on 11/30/2010

Good to know the number of decimal places affects the answer. Thanks!

32DE12EB89 on 11/30/2010

Does POWER use 120 or 240 volts? :-)

Diana Dee on 12/5/2010

The behavior is not surprising. Books Online says the return value has the same data type as the first argument. Good otherwise! Keep 'em coming, Andy!

ravi on 4/17/2011

EXCELLENT

Keith Badeau on 5/26/2011

Excellent video: short, clear and concise. Thanks.