+ Reply to Thread
Results 1 to 3 of 3

Arithmetic overflow error converting expression to data type int.

  1. Arithmetic overflow error converting expression to data type int.

    select convert(bigint,21568194 * 100)
    Server: Msg 8115, Level 16, State 2, Line 1
    Arithmetic overflow error converting expression to data type int.

    Why does this happen, How do I fix?

  2. Re: Arithmetic overflow error converting expression to data type int.

    select convert(bigint,CAST(21568194 AS bigint) * 100)
    OR
    select CAST(21568194 AS bigint) * 100

    --
    Tibor Karaszi, SQL Server MVP
    http://www.karaszi.com/sqlserver/default.asp
    http://www.solidqualitylearning.com/


    "marcmc" wrote in message
    news:BB3435B9-09B1-4260-B03B-5F19E78E084F@microsoft.com...
    > select convert(bigint,21568194 * 100)
    > Server: Msg 8115, Level 16, State 2, Line 1
    > Arithmetic overflow error converting expression to data type int.
    >
    > Why does this happen, How do I fix?



  3. Re: Arithmetic overflow error converting expression to data type int.

    select convert(bigint,CAST(21568194 AS bigint) * 100)
    OR
    select CAST(21568194 AS bigint) * 100

    --
    Tibor Karaszi, SQL Server MVP
    http://www.karaszi.com/sqlserver/default.asp
    http://www.solidqualitylearning.com/


    "marcmc" wrote in message
    news:BB3435B9-09B1-4260-B03B-5F19E78E084F@microsoft.com...
    > select convert(bigint,21568194 * 100)
    > Server: Msg 8115, Level 16, State 2, Line 1
    > Arithmetic overflow error converting expression to data type int.
    >
    > Why does this happen, How do I fix?



+ Reply to Thread