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 vote325 views1 answer
Sql select lowest value row
SQL
5 votes329 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
0 vote332 views1 answer
Sql sum if
SQL
11 votes337 views5 answers
Update table from another table mysql
SQL
1 vote305 views1 answer
Select from one table where not on the other
SQL
1 vote338 views1 answer
Base64 encode sql server
SQL
-1 vote327 views1 answer
Sql show custom constraints
SQL
0 vote336 views1 answer
T-sql email validation
SQL
0 vote343 views3 answers
Condition in count sql
SQL
1 vote312 views1 answer
Xampp import sql file command line
SQL