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 vote153 views1 answer
Strict in postgres SQL
SQL
0 vote193 views1 answer
Kill slow queries mysql
SQL
0 vote192 views1 answer
Mysql make date from 2 column
SQL
0 vote283 views1 answer
Bigrock database connection string
SQL
6 votes185 views1 answer
Oracle trigger after connect
SQL
1 vote190 views1 answer
Tsql find foreign key references
SQL
0 vote211 views1 answer
How to change the field size of an existing column
SQL
0 vote179 views1 answer
Sql period overlap
SQL
0 vote199 views1 answer
Cube oracle
SQL
11 votes209 views3 answers
Sql line numbers
SQL