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 vote94 views3 answers
Django.core.exceptions.improperlyconfigured: error loading mysqldb module. mac
SQL
1 vote151 views1 answer
Moodle query first user access
SQL
0 vote140 views1 answer
Postgresql like
SQL
2 votes147 views1 answer
Add default sql server
SQL
1 vote144 views2 answers
Sql where keyword
SQL
0 vote151 views1 answer
Narural join
SQL
0 vote157 views1 answer
Regex any word except sql
SQL
5 votes157 views1 answer
Oracle list functions
SQL
2 votes137 views1 answer
While loop sql
SQL
0 vote134 views1 answer
Sql sum if
SQL