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

3 votes129 views1 answer
Oracle list privileges
SQL
1 vote132 views1 answer
Date in where on datetime column clause mysql
SQL
0 vote138 views2 answers
Sql trigger difference between for and after
SQL
3 votes90 views1 answer
Ubuntu install postgresql 12
SQL
0 vote131 views1 answer
Display first three characters sql
SQL
0 vote122 views1 answer
Zerar auto increment mysql
SQL
1 vote127 views1 answer
Update from select join
SQL
3 votes124 views2 answers
Sql paging query
SQL
0 vote164 views1 answer
Jpa generationtype sequence mysql
SQL
0 vote141 views2 answers
How to get max from each department in sql
SQL