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 vote307 views1 answer
Can we rollback in sql
SQL
1 vote290 views1 answer
Last 6 months postgresql
SQL
0 vote308 views2 answers
Sql count number of rows after group by
SQL
0 vote301 views2 answers
Collation in sql
SQL
2 votes291 views1 answer
Oracle number to percentage
SQL
1 vote311 views1 answer
Mysql check if string contains comma separated
SQL
1 vote310 views1 answer
Table information in sql server
SQL
1 vote289 views2 answers
Mysql type conversion
SQL
0 vote305 views1 answer
Select count concat string sql server
SQL
0 vote290 views1 answer
Mariadb number format
SQL