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

2 votes292 views1 answer
Sql ignore accents
SQL
11 votes285 views2 answers
Having keyword sql
SQL
0 vote300 views1 answer
Mysql count with two joins
SQL
0 vote389 views1 answer
1422: Explicit or implicit commit is not allowed in stored function or trigger
SQL
1 vote309 views1 answer
Mysql return text after a final full stop
SQL
-1 vote324 views3 answers
My sql alter table
SQL
0 vote351 views1 answer
Sql server phone constraint
SQL
-1 vote275 views1 answer
How to format tables in sqlplus
SQL
0 vote329 views1 answer
Mysql vs sql server performance benchmark
SQL
10 votes306 views4 answers
Inner join in update query mysql
SQL