• you could also use BREAK

    declare @i int

    set @i = 0

    while @i < 60

    begin

    set @i = @i + 1

    print @i

    if @i > 9

    begin

    Print 'exited while statement'

    break

    end

    end