POWER doesn't work for BIGINT?

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Christopher Stobbs SSC-Insane Points: 21098 More actions · Answer 1

I think you might be confused

a bigint takes this

SET @a = 9223372036854775807

PRINT @a

SET @a = POWER(2,31-1)

PRINT @a

AND NOT THIS

SET @a = POWER(2,31)-1

PRINT @a

----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley

:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]

SQL-4-Life

Christopher Stobbs SSC-Insane Points: 21098 More actions · Answer 2

actually maybe I am confused I will look further

----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley

:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]

SQL-4-Life

R. van Laake SSCommitted Points: 1533 More actions · Answer 3

Yep, y'r right, I made a typo.

However, I got the problem fixed, this does the trick:

DECLARE @a BIGINT

SET @a = POWER(CAST(2 AS BIGINT),CAST(62 AS BIGINT))

PRINT @a

Christopher Stobbs SSC-Insane Points: 21098 More actions · Answer 4

yeah that was my next solution was to perhaps cast the vaules as it would prob return the same type as what is passed in 🙂

----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley

:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]

SQL-4-Life