Procedure loop in Oracle to SQL Developer

Question

I have a procedure which is written using Oracle database and now I want to migrate it to SQL Server but I am having an issue when it comes to loop. As far as I know, SQL Server doesn't have "FOR" loop, it only has "WHILE" loop. The code is :

FOR something in columns 
LOOP
PRINT('SOMETHING');
PRINT('SOMETHING');
END LOOP;

I want to convert it to SQL Server syntax but I have a problem when it comes to MS SQL syntax.

Please provide a complete reproducible example. What is columns? What is your current T-SQL code? — astentx
– astentx, Commented Jul 12, 2022 at 6:39

Gnqz · Accepted Answer · 2022-07-12 07:21:55Z

1

You could use cursor:

DECLARE @col_name VARCHAR(128);
DECLARE @col_value VARCHAR(128);

-- declare cursor 
DECLARE columns CURSOR FOR
  SELECT something, other_thing
    FROM table_list;

-- open cursor
OPEN columns;
 
-- loop through a cursor
FETCH NEXT FROM columns INTO @col_name, @col_value;
WHILE @@FETCH_STATUS = 0
  BEGIN
    PRINT CONCAT('SOMETHING: ', @col_name, ' / OTHER_THING: ', @col_value);
    FETCH NEXT FROM columns INTO @col_name, @col_value;
  END;
-- close and deallocate cursor
CLOSE columns ;
DEALLOCATE columns;

answered Jul 12, 2022 at 7:21

Gnqz

3,3823 gold badges28 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Procedure loop in Oracle to SQL Developer

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related