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 vote114 views1 answer
T-SQL Never ending DELETE
SQL
1 vote124 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
0 vote137 views1 answer
Excel vba import data to sql server
SQL
20 votes116 views5 answers
Sql show tables
SQL
0 vote122 views2 answers
How to save result of sqlite query in a table
SQL
0 vote127 views1 answer
Sql server isnull function nor working count
SQL
0 vote131 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
1 vote134 views1 answer
Psql view enum values
SQL
1 vote133 views2 answers
Insert sqlite
SQL
5 votes117 views4 answers
Mysql update column with value from another table
SQL