convert bigint to int

  • I have two variables @sar delared as bigint and @deep declared as int

    I want to convert bigint to int. That is value of @sar to int.

    Is this possible ? If yes How?:hehe:

  • Your Question is not clear

    I think you want to do this

    declare @sar bigint

    declare @deep int

    set @sar = 1234356

    set @deep = 12

    select convert(int,@sar)

    select @deep

    Regards,

    Yousaf Khan

  • The bigint data type is supported where integer values are supported. However, when we are passing the bigint value to integer values, if the value exceeds the integer range it can't assing the bigint value to int.

    declare @sar bigint

    declare @deep int

    begin

    set @sar=3000000

    set @deep =@sar

    select @deep

    end

    here it will not throw any error, since the int range is not exceeded.

    declare @sar bigint

    declare @deep int

    begin

    set @sar=3000000000

    'here it will throw the error.

    set @deep =convert(int,@sar/1000)

    select @deep

    end

    Nandy

  • Dear I think there no such way to convert value from bigint to int

    the only way to change the datatype of int variable to bigint

    @Deep bigint

    If there is any then please post it.

    Regards,

    Yousaf Khan

  • Interesting here... I think that you cannot convert from bigint to int if the range is exceeded otherwise from int to bigint I try and it works!

    There is the ranges for the numeric datatypes:

    bigint -2^63 (-9,223,372,036,854,775,808) to 2^63-1 (9,223,372,036,854,775,807)

    int -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647)

    smallint -2^15 (-32,768) to 2^15-1 (32,767)

    tinyint (0 to 255)

    :w00t:

    ============================================================
    SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =
    http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

  • Thanks yaar ......

    I tried it like that but it throws an error when int range limit is exceeded

  • if your bigint value exceeds the maximum value for int then its not possible to convert.

    "Keep Trying"

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply