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 vote217 views1 answer
How to see the query of a view in mysql
SQL
3 votes151 views1 answer
V$session not found in oracle
SQL
0 vote148 views1 answer
Get all stored procedures in sql server
SQL
0 vote235 views2 answers
Mysql where in maintain order group_concat
SQL
0 vote184 views1 answer
Incorrect datetime value sql table error 1292
SQL
1 vote180 views1 answer
Oracle rolling back
SQL
21 votes202 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote213 views2 answers
Get item by composite primary key mysql
SQL
2 votes192 views2 answers
Created at and updated at in mysql
SQL
0 vote192 views1 answer
Login failed for login due to trigger execution
SQL