Log in  ::  Register  ::  Not logged in

## convert bigint to int

 Author Message sar_kan25 Grasshopper Group: General Forum Members Points: 24 Visits: 56 I have two variables @sar delared as bigint and @deep declared as intI want to convert bigint to int. That is value of @sar to int.Is this possible ? If yes How? Yousaf Khan SSC-Addicted Group: General Forum Members Points: 463 Visits: 113 Your Question is not clearI think you want to do thisdeclare @sar bigint declare @deep intset @sar = 1234356set @deep = 12select convert(int,@sar)select @deep Regards,Yousaf Khan Nandy SSC-Enthusiastic Group: General Forum Members Points: 104 Visits: 210 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 bigintdeclare @deep intbegin set @sar=3000000 set @deep =@sar select @deependhere it will not throw any error, since the int range is not exceeded.declare @sar bigintdeclare @deep intbegin set @sar=3000000000'here it will throw the error. set @deep =convert(int,@sar/1000) select @deependNandy Yousaf Khan SSC-Addicted Group: General Forum Members Points: 463 Visits: 113 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 bigintIf there is any then please post it.Regards,Yousaf Khan Dugi SSCrazy Group: General Forum Members Points: 2150 Visits: 3511 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) ` ============================================================SELECT YOUR PROBLEM FROM SSC.com WHERE PROBLEM DESCRIPTION =http://www.sqlservercentral.com/articles/Best+Practices/61537/ sar_kan25 Grasshopper Group: General Forum Members Points: 24 Visits: 56 Thanks yaar ......I tried it like that but it throws an error when int range limit is exceeded ChiragNS Hall of Fame Group: General Forum Members Points: 3387 Visits: 1865 if your bigint value exceeds the maximum value for int then its not possible to convert. "Keep Trying"