December 31, 2008 at 12:05 am
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:
December 31, 2008 at 12:42 am
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
December 31, 2008 at 12:45 am
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
December 31, 2008 at 1:41 am
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
December 31, 2008 at 2:42 am
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:
December 31, 2008 at 2:42 am
Thanks yaar ......
I tried it like that but it throws an error when int range limit is exceeded
December 31, 2008 at 3:25 am
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