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

12 votes232 views1 answer
Docker mysql random root password
SQL
0 vote244 views2 answers
Suse stop MySQL
SQL
0 vote238 views1 answer
Access denied for user 'root'@'localhost' (using password no) stackoverflow
SQL
2 votes252 views1 answer
Alter table add column and foreign key mysql
SQL
13 votes229 views2 answers
Sql join
SQL
1 vote266 views1 answer
Mariadb get column names from table
SQL
0 vote251 views1 answer
How to find lowest in sql
SQL
0 vote245 views1 answer
Select even number id data from table
SQL
25 votes251 views3 answers
How to use a database to see tables mysql
SQL
15 votes223 views2 answers
How to drop database name in postgresql
SQL