EXIT FOR Statement - Informix to SQL Server Migration

In Informix, you can use the EXIT FOR statement to leave the FOR range loop. In SQL Server, you can use the BREAK statement.

Informix:

  CREATE PROCEDURE loop1()
    DEFINE i INTEGER;      
    -- Run a loop
    FOR i = 1 TO 10
 
      -- Leave the loop
      IF i = 5 THEN
        EXIT FOR;
      END IF;
 
    END FOR;
  END PROCEDURE;

SQL Server:

  CREATE PROCEDURE loop1 AS 
    DECLARE @i INTEGER;      
    -- Run a loop
    SET @i = 1;
     WHILE @i <= 10 BEGIN
 
      -- Leave the loop
      IF @i = 5 BEGIN
        BREAK;
      END 
 
    SET @i = @i + 1;
    END
  GO

For more information, see Informix to SQL Server Migration.