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