for testing folating point the same can be written as

DECLARE @i float,@rc int

set @i = 0

while @i <> 1

begin

set @i = @i + 0.1

end

select @i

then the loop never executes.

I observer some intrested behavior of floating point

DECLARE @i float,@rc int

set @i = 0

while @i <> 1

begin

set @i = 0.8999 + 0.1

end

select @i

the above will never executes. we use 0.1 instead of 0.8999 other wise we can use 0.2,0.3,0.4,0.5,0.6,0.7,0.8.but when i added 0.9 it executes

and show 1 as answer.