## convert bigint to int

 Author Message sar_kan25 SSC-Enthusiastic Group: General Forum Members Points: 176 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 Eights! Group: General Forum Members Points: 901 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 Mr or Mrs. 500 Group: General Forum Members Points: 590 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 Eights! Group: General Forum Members Points: 901 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 SSChampion Group: General Forum Members Points: 10124 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 SSC-Enthusiastic Group: General Forum Members Points: 176 Visits: 56 Thanks yaar ......I tried it like that but it throws an error when int range limit is exceeded ChiragNS SSChampion Group: General Forum Members Points: 14569 Visits: 1865 if your bigint value exceeds the maximum value for int then its not possible to convert. "Keep Trying"