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.
Malleswarareddy
I.T.Analyst
MCITP(70-451)