Sql server loop over query

DECLARE @id INT
DECLARE @name NVARCHAR(100)
DECLARE @getid CURSOR

SET @getid = CURSOR FOR
SELECT table.id,
       table.name
FROM   table

OPEN @getid
FETCH NEXT
FROM @getid INTO @id, @name
WHILE @@FETCH_STATUS = 0
BEGIN
    EXEC stored_proc @varName=@id, @otherVarName='test', @varForName=@name
    FETCH NEXT
    FROM @getid INTO @id, @name
END

CLOSE @getid
DEALLOCATE @getid

Source: stackoverflow.com

Similar codes

0 vote148 views1 answer
Stop and start mysql
SQL
-1 vote133 views1 answer
Get month and year from date in mysql sequelize
SQL
11 votes121 views4 answers
Round in sql
SQL
1 vote139 views1 answer
Oracle select row max date
SQL
0 vote167 views1 answer
Copy from one table to another postgres using matching column
SQL
3 votes91 views1 answer
Sql set null
SQL
0 vote134 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
1 vote119 views1 answer
Mysql batch insert
SQL
0 vote127 views1 answer
Oracle locked objects
SQL
0 vote111 views1 answer
Sub blocks in sql
SQL