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 vote360 views1 answer
Mysql select count if contains
SQL
0 vote328 views2 answers
Android sqlite tutorial for beginners
SQL
2 votes362 views2 answers
Postgres drop column if exists
SQL
0 vote339 views2 answers
Sql server set default value equal to auto increment
SQL
0 vote362 views1 answer
Oracle array
SQL
0 vote339 views1 answer
Sql server express download
SQL
0 vote409 views1 answer
Finding leap year in sql
SQL
0 vote361 views1 answer
Mariadb date equals to current_date plus days
SQL
0 vote372 views1 answer
Allow null in psql
SQL
1 vote352 views1 answer
Mysql view current queries
SQL