Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    6

    Unanswered: Arithmetic overflow

    Msg 247, Level 16, State 1 , Line 1
    Arithmetic overflow during implicit conversion of NUMERIC value '10147156' to a NUMERIC field . Arithmetic overflow occurred.
    I am getting this error while running stored procedure .
    How to avoid this error ?

  2. #2
    Join Date
    Nov 2002
    Posts
    207
    Will be of more help if you could pls. post the piece of code giving you the error.

  3. #3
    Join Date
    Jun 2004
    Posts
    7

    More explaination of the problem.

    Is this problem will get solve if I changed datatype TINYINT to SMALLINT.

    Please Suggest.
    Thanks.
    Regards,
    Amol

Posting Permissions

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