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 vote229 views1 answer
Insert value in identity
SQL
0 vote197 views1 answer
Mysql remove tabs from string
SQL
3 votes209 views2 answers
Create schema postgres
SQL
0 vote231 views1 answer
Sql server pivot rows to columns
SQL
-1 vote236 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
1 vote208 views1 answer
Mysql text to decimal
SQL
0 vote211 views1 answer
Use of undefined constant mysql_assoc - assumed
SQL
3 votes226 views2 answers
Host '' is not allowed to connect to this MySQL server
SQL
0 vote202 views2 answers
Plsql regex match whole word
SQL
1 vote199 views1 answer
Oracle update with sequence
SQL