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 vote219 views1 answer
Sql server count all tables rows
SQL
2 votes254 views1 answer
Mysql shell insert into
SQL
6 votes255 views2 answers
WHERE value IS sql
SQL
3 votes218 views2 answers
How to start mysql in terminal
SQL
17 votes227 views3 answers
Postgresql list users
SQL
0 vote207 views1 answer
Create bdd mysql
SQL
13 votes205 views6 answers
Mysql update from select
SQL
0 vote199 views1 answer
Mariadb number format
SQL
0 vote211 views1 answer
Can't connect to postgresql mac os
SQL
22 votes213 views6 answers
Create sql table
SQL