troubleshooting Question

Adding 2 coulmns into 1

Avatar of proudpaki9
proudpaki9 asked on
SBS
14 Comments1 Solution332 ViewsLast Modified:
Hello:

I have 2 fields Field1(int) and Filed2 (bigint) and here is the statement:
Update [dbo].[591726273]
set [LINK] = [Field1] + left([Field2],18)
LINK is the data type bigint
I am getting the following error message:
Server: Msg 248, Level 16, State 1, Line 1
The conversion of the varchar value '200705311867085988' overflowed an int column. Maximum integer value exceeded.
The statement has been terminated.

How do I fix this problem?

Thank you.
ASKER CERTIFIED SOLUTION
Ted Bouskill
Senior Software Developer
Join our community to see this answer!
Unlock 1 Answer and 14 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 14 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros