توابع بازگشتی در SQL Server

INSERT INTO @prime
SELECT @i;

WHILE (@i <= @n)
BEGIN
  DECLARE @j INT = 2;

  WHILE (@j * @j <= @i)
  BEGIN
    IF (@i % @j = 0)
    BEGIN
      DELETE FROM @prime WHERE number = @i;
      BREAK;
    END;

    @j = @j + 1;
  END;

  @i = @i + 1;
END;

RETURN
(
SELECT * FROM @prime
);
END;