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

37 votes338 views3 answers
Postgresql insert column
SQL
1 vote392 views1 answer
Import sql file from laravel
SQL
9 votes593 views2 answers
Current date in postgresql minus 1 day
SQL
1 vote320 views1 answer
Mysql column start with string
SQL
1 vote343 views1 answer
Flask sqlalchemy default value
SQL
23 votes333 views4 answers
How to uninstall postgresql in ubuntu
SQL
0 vote308 views7 answers
10 random questions use python and SQL
SQL
0 vote348 views1 answer
Find how many tables in database sql query
SQL
0 vote336 views1 answer
Create table sql generator
SQL
0 vote336 views1 answer
Regex mongoose
SQL