Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
saurabhjj
Starting Member
13 Posts |
 Posted - 2007-10-01 : 14:12:57
|
| can any one please let me know how do i calculate power of a number in sql servereg. 3 to the power of 2 shuld give me 9 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-01 : 14:15:16
|
| Check out the POWER function in BOL.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-01 : 14:58:34
|
| I get 9 when I use the POWER function, not sure why you edited your post with that information. Have you looked up POWER in BOL as suggested?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Kristen
Test
22859 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-10-01 : 15:14:09
|
I'm not familiar with the word "patience".  His edit was 30 minutes after my post though.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-01 : 15:19:19
|
| Yeah, I saw that too ... and wondered whether BoL had been read ... Ho!Hum! |
|
|
|
|
|
|
power in sql server