Home Forums Article Discussions Article Discussions by Author Discuss content posted by Carlo Romagnano SET ROWCOUNT and table variable RE: SET ROWCOUNT and table variable

  • August 29, 2010 at 11:25 pm

    #1213608

    I can't say i completely understand this issue.

    The while statement dont not stop because @i will never be equal to 1

    So how come the following select return 1 ?

    DECLARE @i float

    set @i = 0

    set @i = @i + 0.2

    set @i = @i + 0.2

    set @i = @i + 0.2

    set @i = @i + 0.2

    set @i = @i + 0.2

    SELECT 1

    WHERE @i=1