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

  • gs06sid
     + 0 comments
    DECLARE @i INT = 3
DECLARE @result VARCHAR(7000) = "2"

WHILE @i <= 1000
BEGIN
    DECLARE @prime INT = 1
    DECLARE @j INT = 2
    
    WHILE @j < @i
    BEGIN
        IF(@i%@j = 0)
        BEGIN
            SET @prime = 2
            BREAK
        END
        SET @j = @j + 1
    END
    
    IF(@prime = 1)
    BEGIN
        SET @result = @result + "&" + CAST(@i AS VARCHAR)
    END
    
    SET @i = @i + 1
END
PRINT(@result)