We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Alternative Queries
  4. Print Prime Numbers
  5. Discussions

Print Prime Numbers

  • j_ibarralemp
     + 0 comments

    Took a way more computationally expensive path here, but still works. Learned quite a bit from the other solutions below.

    DECLARE @n AS INT = 2
DECLARE @s AS VARCHAR(1000) = ''
WHILE @n < 1000
BEGIN
    DECLARE @m AS INT = @n - 1, @p AS INT = 1
    WHILE @m >= 2 AND @p = 1
    BEGIN
        IF @n % @m <> 0
            SET @m = @m - 1
        ELSE
            SET @p = 0
        END
    IF @p = 1 AND @n > 2
        SET @s = @s + '&' + CAST(@n AS VARCHAR(4))
    ELSE IF @p = 1
        SET @s = @s + CAST(@n AS VARCHAR(4))
    SET @n = @n + 1
END
PRINT @s