Results 1 to 3 of 3

Thread: OPENQUERY Not Failing on Overflow error

  1. 05-05-2009, 03:58 PM #1
    dba723
    dba723 is offline Registered User
    Join Date
    Sep 2002
    Posts
    3

    OPENQUERY Not Failing on Overflow error

    I've got an OPENQUERY query that I'm running. Part of its syntax is to convert a string field to INT. There is one string when converted is actually BIGINT. If I run the query locally on that server I get the "overflow" error. If I run it as OPENQUERY I'm getting no errors.

    What the heck is up with that?
    Reply With Quote Reply With Quote
  2. 05-06-2009, 08:38 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    What's value in the column to convert?
    Reply With Quote Reply With Quote
  3. 05-06-2009, 09:02 AM #3
    dba723
    dba723 is offline Registered User
    Join Date
    Sep 2002
    Posts
    3
    It's '16011000000', but don't get wrapped up in the conversion of the value. I know how to handle that. What I need explained is why OPENQUERY is not returning an error when an arithmetic overflow occurs.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules