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 vote206 views1 answer
Mysql workbench not showing schemas
SQL
32 votes203 views6 answers
Sql count where
SQL
0 vote223 views1 answer
Sql find gaps in date ranges
SQL
0 vote207 views1 answer
Add computed column to table sql server
SQL
0 vote208 views1 answer
Sql period overlap
SQL
18 votes190 views2 answers
Sql comments
SQL
0 vote203 views1 answer
Sql anywhere create procedure
SQL
0 vote205 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote212 views1 answer
Create database like
SQL
-1 vote192 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL