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

1 vote132 views2 answers
T sql get foreign key
SQL
2 votes214 views2 answers
How to DROP a table in mysql
SQL
2 votes173 views1 answer
Select a certain number of entries from select mysql
SQL
10 votes158 views6 answers
Sql between
SQL
10 votes141 views6 answers
Mysql delete duplicates
SQL
1 vote148 views1 answer
SQL query to get all table records count from a database
SQL
0 vote132 views1 answer
Dnsmasq.conf location macos
SQL
0 vote140 views1 answer
Inner joint
SQL
7 votes145 views1 answer
Minecraft forge server host
SQL
4 votes152 views2 answers
Sql offset
SQL