Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Arithmetic Overflow message- sql server

Status
Not open for further replies.

hgrick

IS-IT--Management
Jul 19, 2006
7
US
Hi,

I'm trying to convert varbinary to numeric data type and getting below error message

Server: Msg 8115, Level 16, State 6, Line 1

Arithmetic overflow error converting varbinary to data type numeric.

Here is the script I'm executing:

print cast(0x635B3441797440B6920AB1C443363A46 as numeric(18,0))

Please help me to convert the data.
Thanks
 
Try 'as integer'?

HTH,

Alex


Professor: But what about your superintelligence?
Gunther: When I had that there was too much pressure to use it. All I want out of life is to be a monkey of moderate intelligence who wears a suit. That's why I've decided to transfer to Business School.
Professor: NOOOOOOOOOOOO.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top